Composite Non-Clustered Indexes – does the Column Order matter?
When I talk about indexes, people always ask me if the sorting order of the columns in a composite Non-Clustered Index matters? The short answer is always “It depends”. Let’s have a look on it why “it depends”.. Singleton Lookups When you have queries which perform Singleton Lookups on your tables, the sorting order of …
Composite Non-Clustered Indexes – does the Column Order matter? + read more
