Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
Use EXPLAIN to analyze the query execution plan and identify bottlenecks.
B
Rewrite the query to use subqueries and temporary tables for intermediate results.
C
Ensure that the tables involved in the query are properly indexed.
D
All of the above.
