Question
Why can indexing join keys improve a warehouse query?
Select an option. Your answer will be checked instantly.
Correct Answer: A. It can reduce the cost of locating and matching rows between tables
Explanation:
Indexes can support efficient probes, ordering, or reduced scans on join columns.
The optimizer still chooses the join algorithm based on row counts and costs.
Leave a Reply