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
Last activity: Jan 29, 2023, 11:00 AM