Blogs about: The Best Of The Oracle Sponge
Featured Blog
The Three Pillars of Oracle Data Warehousing
Introduction This is a basic topic for Oracle data warehousing beginners, based on some ideas that I’m hoping will stop buzzing round in my head if I commit them to virtual paper. There are thre… more →
The Oracle Sponge
The Three Pillars of Oracle Data Warehousing
— 14 comments
David Aldridge wrote 3 years ago: Introduction This is a basic topic for Oracle data warehousing beginners, based on some ideas that I … more →
My Dishwasher is List Partitioned
— 6 comments
David Aldridge wrote 3 years ago: My dishwasher has two levels in it. The bottom level is for plates and Large Things, the top level i … more →
Predicate Pushing And Analytic Functions
— 9 comments
David Aldridge wrote 3 years ago: I'm sure that there must be a fair number of Oracle professionals who carry around in their head … more →
ORA-12034: materialized view log younger than last refresh
— 11 comments
David Aldridge wrote 4 years ago: Dabblers in the art of the materialisation of views may be used to seeing this error message, and it … more →
Designs That Balance ETL and Report Performance
— 30 comments
David Aldridge wrote 4 years ago: It seems to me that there is sometimes a very difficult balance to strike, between optimizing the st … more →
Dates as Key Values: Natural or Synthetic?
— 29 comments
David Aldridge wrote 4 years ago: Here's a question: when deciding whether to use a date datatype as a key value, why does there s … more →
Statistics By Block Sampling
— 8 comments
David Aldridge wrote 4 years ago: If you're just joining us, I'd suggest that you scroll down and read the original article th … more →
Writing Good SQL
— 10 comments
David Aldridge wrote 4 years ago: This is prompted by a question asked by eastmael at the Oracle DBA Forum — "what I'd … more →
Update on Histograms
— 6 comments
David Aldridge wrote 4 years ago: OK, that was a bad example. Here's a new approach. When the Oracle documentation talks about ske … more →
Using Histograms on Evenly Distributed Values
— 3 comments
David Aldridge wrote 4 years ago: A quick demo … here's a script … drop table demo_hist / create table demo_hist as se … more →
