Which component of the SQL Server database engine builds a physical execution plan from a SQL query?
A)query optimizer
B)query editor
C)query execution planner
D)query processor

Question

Quizplus · Accepted Answer

The query optimizer is responsible for building a physical execution plan from a SQL query. It analyzes the query and determines the most efficient way to execute it, taking into consideration factors such as available indexes, table statistics, and system resources. The query editor is a tool used to write and edit SQL queries, but it does not build execution plans. The query execution planner and query processor are not components of the SQL Server database engine.

Which Component of the SQL Server Database Engine Builds a Physical