Session
Roam with the Beast: Let the Oracle Cost-Based Optimizer run!
In this presentation, we delve into the heart of Oracle Database's Cost-Based Optimizer (CBO), and explore why allowing it to roam freely leads to optimal long-term query performance.
Discover why the key to unlocking the CBO's potential lies not in restraining it with hints or profiles but in empowering it with a wealth of knowledge. We'll explore the art of crafting strategic indexes, harnessing the power of statistics, and other ingenious meta-information techniques to guide the CBO's decision-making process. Learn how to keep the optimizer dynamic and responsive, adapting to evolving data landscapes without sacrificing performance.
Buckle up as we deal with 10 operations having a reputation of being "bad" or "slow" – from Hash Joins to Table Access Full – that might sound like performance pitfalls. But, in truth, they can be powerful allies when orchestrated under the right circumstances.
Join us on a journey where seemingly bad choices transform into performance triumphs, demonstrating that in the realm of Oracle optimization, knowledge is power, and the true mastery lies in understanding and supporting the CBO rather than attempting to control its every move. Rule less, optimize more!

Martin Klier
Senior Data Platform Expert at Performing Databases GmbH
Mitterteich, Germany
Links
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top