Index Selectivity: The more selective an index is (i.e., the fewer rows it returns), the?

more likely it is to be chosen. The optimizer prefers indexes that significantly reduce

the number of rows processed.