On Wednesday, 1st of August, I’ll be presenting another free webinar hosted by 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 SamplingVirtual 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.

Please visit my blog for more Oracle related stuff.