Speeding up Oracle Queries with Materialized View Rewrite
Materialized views (MV’s) – the developers go-to tool for poor performing queries. 🙂 Of course that isn’t really their only …
Category: SQL
Oracle Row Generators and Cardinality
I’m quite a fan of row generators. If I know I need a row for every day of the year …
The Basics of Consumption Queries in SQL
I was inspired to post this blog by a post on the OTN Forums where a user was asking about …
Calculated Measures in Analytic Views
Back onto analytical views, today I’m going to demo using calculated fact measures in analytic views as opposed to standard …
Date Tracking with Temporal Validity in Oracle 12c
It’s always nice to see new database features, and I especially like to see features which implement concepts that are …
Using Data Dictionary Metadata in Oracle 12.2 Analytic View Applications
In my previous blog post An Introduction to Analytic Views in Oracle 12.2 I briefly mentioned that one of the …
An Introduction to Analytic Views in Oracle 12.2
In my last blog post on Oracle Database 12.2 I mentioned the new Analytics View feature. Now in this post …
Relationship Issues
Relationship Issues No, this isn’t the latest agony aunt column – I’m talking about data relationships! Specifically, relationships between columns …
Using LISTAGG and other meta columns in ODI interfaces
I recently needed to use the LISTAGG function in a custom Oracle ODI interface. However to my dismay I found …
(Mis)using the WITH clause in Oracle
The WITH clause (or subquery factoring clause) is a very useful construct. It allows us to materialize the results of …