Which step of query optimization involves choosing the most efficient execution plan for a SQL query?

  • Execution
  • Fetching
  • Optimization
  • Parsing
The step of query optimization that involves choosing the most efficient execution plan for a SQL query is Optimization. During this phase, the database optimizer analyzes the query and generates alternative execution plans based on factors such as available indexes, table statistics, and system resources. The goal is to select the execution plan that minimizes the query's resource consumption and maximizes its performance. Once the optimal plan is determined, it is executed by the database engine.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *