At scale, SQL performance tuning goes beyond indexing—it requires understanding Oracle Optimizer internals, execution engine behavior, latch contention, and I/O patterns. This case study dives deep into a production-critical query optimization using CBO (Cost-Based Optimizer), AWR reports, and execution plan analysis.