If you were tasked with optimizing a slow SQL query, what steps would you take to improve its performance?

Situational