Likely bottleneck: Full table scan on the 500-million-row transactions table. The join to accounts and branches adds overhead. - Recommendation: Range-partition the transactions table by transaction_date (monthly partitions). This enables partition elimination so the monthly report reads only the re