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…