A transformation query joining several large tables has become too slow and expensive. How would you optimize it? Explain what you would inspect in the execution plan and how you would decide between partitioning, clustering, pre-aggregation, indexing, or changing the join strategy.
Write your answer in the field below and click the "Check!" button.