Intermediate
Database Management Systems
Q53 / 100
What is query optimization?
Correct! Well done.
Incorrect.
The correct answer is B) The database engine's process of selecting the most efficient execution plan for a query using statistics, join algorithms, and index choices
B
Correct Answer
The database engine's process of selecting the most efficient execution plan for a query using statistics, join algorithms, and index choices
Explanation
The query optimizer (cost-based optimizer) evaluates multiple execution plans, estimating cost using statistics (row counts, cardinality, data distribution) and choosing the cheapest plan.
Progress
53/100