You are optimizing a SQL query for a data pipeline that involves multiple joins and aggregations. The query currently takes a long time to execute. Which of the following techniques would you use to improve the query performance?