Sample Header Ad - 728x90

Query for MAX/MIN of non-clustered index field for partitioned table

1 vote
1 answer
199 views
We have a table partitioned on a two-year based hash function from the system date at the insertion time (let's call it PartitionKey). It also has a non-clustered index on a single field (Key). We insert millions of rows a day. If I run the below query, will it be resolved solely based on the non-clustered index on Key?
SELECT MAX(Key), MIN (Key) FROM MyTable
Asked by PM 77-1 (123 rep)
Jan 27, 2023, 06:10 PM
Last activity: Jan 29, 2023, 11:00 AM