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.
OOps! You are currently offline.