Predicate Evaluation Order – Using Generic Fields
I thought this worth talking about as I’ve been in discussions with a number of people recently around best practices …
Category: SQL
Post Load Processes – Don’t Neglect Your Statistics!
It is quite common for warehouse developers to customise standard processes to add additional fields. Ideally this is done by …
Integrating external command line tools with Oracle data
One thing I find interesting to explore is the integration of different tools with Oracle which may not always be …
Generating Rows Automatically in Oracle
Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 2
If you missed part 1 then you can find it here. In this post I’ll be focussing on a somewhat common …
Star Transformations with Bitmap Indexes
One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 1
I wasn’t too sure of what title to use for this blog post. I wanted to share some things that …