Statistics are very important to the way in which the ____ assesses the best way to execute a query.
A) optimizer
B) RDBMS
C) tuning engine
D) performance engine

Question

Quizplus · Accepted Answer

The optimizer uses statistics to determine the best execution plan for a query by analyzing the data distribution and estimating the number of rows to be returned from each table involved in the query. The RDBMS, tuning engine, and performance engine are related to the database management system as a whole but are not directly involved in query optimization.

Statistics Are Very Important to the Way in Which the ____