Question

The optimizer that explores the space of all query-evaluation plans is called ________.
 

• A. cost-based
• B. plan-based
• C. estimate-based
• D. count-based

Hint:

Cost-based optimizers are efficient for complex queries and large datasets, as they minimize execution time by considering all possible plans.

Answer 1

The Correct Option is A

A cost-based optimizer is responsible for exploring different query evaluation plans and selecting the one that minimizes the estimated cost. It evaluates the cost of different execution strategies based on factors such as the amount of data and the number of joins involved.