Rittman Mead - Delivered Intelligence

Well, the turkey’s stuffed, the pies are minced and the presents are wrapped. Today was my last day in the office, and apart from a day over the Christmas break when I’ll be going in just to get a bit of peace and quiet, that’s it for me now until the New Year.
It’s been an [...]

It’s that time of year again when I start to think about the appraisals for the team I look after. If any of you have completed appraisal forms in the past, you’ll know that one of the sections is usually along the lines of “What do you see as your objectives for the next twelve [...]

I mentioned the other day that a new version of AWM was now available following the release of the 10.2.0.3 patch for Oracle Database 10g. One of the new features that this latest version of AWM comes with is the Sparsity Advisor.
I covered the PL/SQL Sparsity Advisor earlier in the year, but at the time [...]

… our use of an index organized table in our ETL process and I promised to jot a quick note on it. So here goes.
There are various combinations of database functionality that I do not like mixing in a data warehouse. For instance I impose rigorous RI checking in the staging layer of my typical [...]

The Oracle Sponge makes a timely comment on statistics on partition keys. Having the right (and not just some!) statistics on a data warehouse table is often the factor that tips the balance between an efficient query and one that causes abject misery in attempts to find what is wrong and how to tune things [...]