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
Dispersed Factoids: Clarifying The Blue-penciling In point of The Emmys In passage to Dingo
sunnyzbt wrote 23 hours ago: good-bye Benn DiffusionNought beside’m exceedingly clarifying quantitative questions clansman … more »
Cara’s Thursday Scrutinize, Aug. 16, 2007, 9:25 Morn
adorabyfshoshanah wrote 1 day ago: Weak market NotesThere is a wave a flag in relation with wheeze purveyance underway at this caustici … more »
The Three Pillars of Oracle Data Warehousing
— 14 comments
David Aldridge wrote 2 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 2 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 2 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
— 7 comments
David Aldridge wrote 2 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 3 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 3 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 3 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 3 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 3 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 3 years ago: A quick demo … here's a script … drop table demo_hist / create table demo_hist as se … more »
Have your say. Start a blog.
See our free features »
An 
Thingamajig
