Question
For a composite rowstore index, why does the order of key columns matter?
Select an option. Your answer will be checked instantly.
Correct Answer: A. The leading columns determine which search predicates and sort orders can use the index efficiently
Explanation:
B-tree navigation is most effective from the leftmost key prefix.
Key order should reflect selective filters, joins, and required ordering.
Leave a Reply