Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are tasked with tuning a query in a big data environment to improve its performance. The query involves filtering a large dataset based on specific conditions. Which of the following techniques would you use to optimize the query performance?
A
Increase the parallelism of the query execution.
B
Use a caching mechanism to store intermediate results.
C
Implement indexing on the columns used in the filter conditions.
D
All of the above.