Which component of an relational database query optimizer translates high-level SQL declarative statements into an efficient execution plan?
ADDL Interpreter
BQuery Optimizer
CTransaction Manager
DBuffer Manager
Explanation
The Query Optimizer evaluates multiple relational algebra equivalent execution plans for an SQL query and chooses the plan with the lowest estimated CPU and I/O execution cost.
Exam Relevance
- Topic: Database Management Systems
- Subtopic: Query Processing & Optimization
No Comments