In a couple of days, on Wednesday, 1st of August, I'll be presenting another free webinar hosted at AllThingsOracle.com.
Although it is called "Oracle Cost-Based Optimizer Advanced Session", don't be mislead by the title.
It is not a truly "advanced" session, but rather I'll try to delve into various topics that I could only mention briefly or had to omit completely during the first webinar on the Cost-Based Optimizer.
In principle it's going to be a selection of the most recurring issues that I come across during my consultancy work:
- I'm going to spend some time on statistics and histograms in particular and what I believe are the most important aspects to understand regarding them
- Why the clustering factor of indexes gathered by the statistics collection might be wrong (this was only briefly mentioned in the first webinar)
- Using the wrong datatype and how this impacts the estimates of the optimizer is going to be another potential topic
- Implicit datatype conversions are also an issue I come across quite frequently (Tom Kyte covered this already to some extent in one of the previous AllThingsOracle.com webinars I believe)
- Last but not least Dynamic Sampling, Virtual Columns and Extended Statistics are also worth to talk about if time permits it
This time I'm going to use only a couple of slides and mainly will run through some test cases that hopefully allow a live demonstration of what I'm talking about.
You can find more details and register here.
Slides for OOW16 Session Preventing Bad SQLs
2 days ago