Oracle Insider

David Aldridge: Indexing Options for Change Data Capture

oraclesponge.wordpress.com17 comments

I just posted this question to the Oracle list, but thought I might post it here in case that reaches a wider audience. It also may be a situation that others in the DW arena have faced before.
 

I have a large and…

David Aldridge: Testing a No-statistics Environment.

oraclesponge.wordpress.com12 comments

I am absolutely sick and tired of dealing with issues where misleading partition statistics (for example) cause ETL queries to go crazy and try to sort-merge tables with tens of millions of rows each.
Since we’re…

David Aldridge: An Empassioned and Meaningless Debate

oraclesponge.wordpress.com9 comments

“See-qwel” or “S-Q-L”? Have your say on this highly important matter here, and help shape the future of our industry.

Discarding the Output of a Select Statement

oraclesponge.wordpress.com9 comments

I’ve wondered before about a convenient way to tackle a particular problem — you want to run a select for a big bunch of rows, maybe for measuring wait events for a tricky query, but you want to discard the output…

Testing a No-statistics Environment.

oraclesponge.wordpress.com8 comments

I am absolutely sick and tired of dealing with issues where misleading partition statistics (for example) cause ETL queries to go crazy and try to sort-merge tables with tens of millions of rows each.
Since we’re…