Question
What does high index selectivity mean?
Select an option. Your answer will be checked instantly.
Correct Answer: A. A predicate identifies a relatively small fraction of table rows
Explanation:
Selective predicates narrow the search to few rows.
B-tree indexes provide greater benefit when they avoid reading most of the table.
Leave a Reply