Which component converts SQL queries into an efficient execution plan?

Options

  • A. Query optimizer
  • B. File manager
  • C. Operating system scheduler
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Query optimizer

Detailed Explanation

  • Query optimizer: Selects an efficient execution strategy for a SQL query.
  • It evaluates alternative execution plans and estimates their costs.
  • Its objective is to improve query performance.