Welcome to my Oracle blog and here are the Posts.
My book Expert Oracle SQL is out now! This book has over 600 pages to help you understand how to tune SQL statements and manager statistics in a runtime environment. See your country’s Amazon website for more details.
I do not blog on a regular basis. Only when I find something interesting to say that doesn’t seem to be available elsewhere. So if you are interested in what I have to say why not set up an RSS feed or use the “Follow” button on the right?
You will see pages on the right that provide links to my published articles, contact details and so on.
The UKOUG 2012 national conference presentation “Star Transformations” can be found here:
The UKOUG 2012 national conference presentation “The MODEL clause explained” can be found here:
The material for my beginner’s guide to SQL tuning presented at the UKOUG 2011 national conference can be found here:
The material for my UKOUG Stabilising Statistics talk can be found here:
The script for my UKOUG Index Clustering Factor Deep Dive talk can be found here:
The powerpoint presentation is here:
Note: The script from my talk “Advanced SQL for PL/SQL Programmers” at the UKOUG 2008 national conference and the 2009 Scottish Conference can be found here:
The powerpoint presentation can be found
To use this script you will need to create a suitably privileged account called “SCOTTBIG”. Good luck!
By the way: the reason the example that performs aggregates using analytic functions runs so slowly is (as I suspected) because of the unused columns. Replace ‘*’ with a smaller number of columns and it runs like a champ!