Question
What is the fundamental goal of database query optimization?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Choose an execution strategy with low estimated resource cost while preserving correct results
Explanation:
The optimizer compares valid access, join, and aggregation alternatives.
Its chosen plan should produce the same correct result with efficient resource use.
Leave a Reply