Tony's Oracle Tips

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 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:

http://tonyhasler.files.wordpress.com/2012/12/star-transformations.pptx

The UKOUG 2012 national conference presentation “The MODEL clause explained” can be found here:

http://tonyhasler.files.wordpress.com/2012/11/the-model-clause-explained.pptx

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!