Welcome to my Oracle blog and here are the Posts.
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?
You will see pages on the right that provide links to my published articles, contact details and so on.
The material for my beginner’s guide to SQL tuning presented at the UKOUG 2011 national conference can be found here:
http://www.aberdour.demon.co.uk/beginnerstuning.zip
The material for my UKOUG Stabilising Statistics talk can be found here:
http://www.aberdour.demon.co.uk/stabilising_statistics.zip
The script for my UKOUG Index Clustering Factor Deep Dive talk can be found here:
http://www.aberdour.demon.co.uk/clustering_factor.sql
The powerpoint presentation is here:
http://www.aberdour.demon.co.uk/index_clustering_factor_deep_dive.ppt
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:
http://www.aberdour.demon.co.uk/advanced_sql_for_plsql_programmers.sql
The powerpoint presentation can be found
here:
http://www.aberdour.demon.co.uk/advanced_sql_for_plsql_programmers.ppt
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!
