Falling BETWEEN the Cracks Of Cost-Based Optimizer
![Patrick Jolliffe](https://swissouc.ch/wp-content/uploads/2023/10/Patrick.jpg)
Patrick Jolliffe
13:40
Tuesday, 30 January 2024
![conference-61](https://swissouc.ch/wp-content/uploads/2023/09/conference-61.png)
Falling BETWEEN the Cracks Of Cost-Based Optimizer
This session focuses on a cardinality mis-estimate dealing with ‘BETWEEN’ conditions and ‘OR’ expansions in a query which caused a real-world performance problem.
We’ll use some mathematics to understand exactly what went wrong.
About Patrick
Patrick started as a C Developer, before gradually migrating towards Database Administration, focused mainly on Oracle performance.
He spent some time living and working in Hong Kong, and now resides in Portugal where he still does a little remote work, and spends the rest of the time walking his dog, watching movies, trying to learn the language and generally recovering from his time in Hong Kong.
Patrick has presented at various international Oracle usergroup and open-source conferences.
![conference-37](https://swissouc.ch/wp-content/uploads/2023/09/conference-37.png)
Register Today!
Don't miss the opportunity to see this session at the Database Circle Conference 2024
Day(s)
:
Hour(s)
:
Minute(s)
:
Second(s)
![conference-16](https://swissouc.ch/wp-content/uploads/2023/09/conference-16.png)
![conference-15](https://swissouc.ch/wp-content/uploads/2023/09/conference-15.png)
Database Circle Conference 2024
Menu
Location
Oracle office
The Circle 32
8058 Zurich
Switzerland