Problem Statement
Tuning a Million-Row Transactions Table Whose Joins Run Slowly You are working on a large database with a table named Transactions that has millions of rows. The table has the columns transaction_id , customer_id , transaction_date and transaction_amount . You notice that queries joining Transactions with other tables take a long time to execute. Which performance tuning technique should you use to improve the query performance?