Strategies for Minimising SQL Execution Plan Instability

Execution Plan Instability – What is the problem? The Oracle Optimizer is a complex piece of software and with every release it becomes more complex. RBO In the beginning, the Optimizer was rule-based. The Optimizer had a ranked list of heuristics used to optimize a query, picking the lowest ranked rule available. This rule-based mode, … Continue reading Strategies for Minimising SQL Execution Plan Instability