Question
What occurs during partition elimination?
Select an option. Your answer will be checked instantly.
Correct Answer: C. The optimizer reads only partitions relevant to the query predicate
Explanation:
A predicate aligned with the partition key lets irrelevant partitions be skipped.
This reduces I/O for date-bounded analytical queries.
Leave a Reply