In the context of a data engineering project, you are tasked with optimizing a complex SQL query that is causing performance issues. The query involves multiple joins and subqueries, and it is executed against a large dataset. What steps would you take to optimize the query and improve its performance?