Not All SQL Server Indexes Are Created Equal

So if the Query Optimizer can check to see if a particular index is useful or not, how can we do the same thing? Fortunately, there is a command that let’s us examine an index and find out if a particular index is selective enough to be used.

Continues…

Leave a Reply

Your email address will not be published. Required fields are marked *