Q. What jobs "Query Optimizer" perform in Mysql?
✅ Correct Answer: (A)
Determine the efficient way to execute a query
Explanation: Determine the efficient way to execute a query: The primary task of the Query Optimizer is to analyze SQL queries and determine the most efficient execution plan. It evaluates various factors such as available indexes, table statistics, and the structure of the query to generate an optimal execution plan that minimizes resource usage and maximizes performance.