Mid SQL Query Structure: The optimizer checks which columns are involved in the query’s? WHERE, JOIN, ORDER BY, and GROUP BY clauses to choose the most appropriate index.