1. Introduction
Modern Oracle databases rely heavily on the Cost Based Optimizer (CBO) to determine the most efficient execution plan for SQL statements. As database objects, statistics, indexes, and optimizer settings change over time, execution plans may also change. While some plan changes improve performance, others can introduce SQL performance regressions and negatively impact business applications.
