What jobs “Query Optimizer” perform in Mysql?

• A. Determine the efficient way to execute a query
• B. Syntax errors
• C. Permissions
• D. All of the mentioned