Question
Why are database statistics important for query optimization?
Select an option. Your answer will be checked instantly.
Correct Answer: D. They help estimate row counts and choose efficient execution plans
Explanation:
The optimizer relies on data-distribution estimates to compare plan alternatives.
Stale or inaccurate statistics can lead to poor join and access choices.
Leave a Reply