Thanks to those of you who attended the Ask Tom Office Hours session on setting up the Oracle Optimizer for a Proof of Concept. Here's a PDF copy of the deck I used and it's available on slideshare too.
A video recording is available here.
It's nearly time for Oracle OpenWorld 2019. As
ever, there are a number of interesting optimizer-related
sessions in the catalogue (and I...
Occasionally I want to get historical information on histogram
changes for a particular table. I have had a script in my back
pocket for a...
I am often asked, “How does Oracle choose which columns need a
histogram?” Also, “Why have I got a histogram on my primary...