O'Reilly logo

Pro Oracle SQL by Jared Still, Riyaj Shamsudeen, Robyn Sands, Kerry Osborne, Karen Morton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16. Plan Stability and Control

Kerry Osborne

One of the most frustrating things about Oracle's Cost Based Optimizer (CBO) is its tendency to change plans for statements at seemingly random intervals. Of course, these changes are not random at all. But because the optimizer code is so complex, it's often difficult to determine why a plan changed. Oracle recognized this issue years ago and has been working to improve the situation for at least a decade. They have provided many tools for identifying when plans change and why they changed. They have also provided numerous tools that allow you to exert varying degrees of control over the execution plans that the optimizer chooses.

This chapter is made up of two main focus areas. The first focus ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required