Can you explain how you would optimize a SQL query that is running slowly?

Technical