Blogs about: Materialized Views
Featured Blog
Applying Predicates and Partition Pruning to MERGE Target Tables
Just a quick pointer to an answer on the Oracle Forum: http://forums.oracle.com/forums/thread.jspa?messageID=3912341#3912341 If you are merging into a data warehouse fact table (not so likely) or a l… more →
The Oracle Sponge
Applying Predicates and Partition Pruning to MERGE Target Tables
— 1 comment
David Aldridge wrote 4 weeks ago: Just a quick pointer to an answer on the Oracle Forum: http://forums.oracle.com/forums/thread.jspa? … more →
Materialized Views Prior Art
jamesjwilcox wrote 5 months ago: Method and apparatus for efficiently refreshing sets of summary tables and … US Pat. 6334128 … more →
Index statistics on complete refreshed materialized views. What is going on?
— 3 comments
tvbeckho wrote 9 months ago: A few days ago I discovered some (to my feeling) buggy behavior during a COMPLETE refresh of a -part … more →
Eliminating workload from the system using materialized views
tvbeckho wrote 10 months ago: The last months I have been looking into a customer’s ETL process. They have a Siebel OLTP and … more →
Materialized Views in Postgres
— 1 comment
Dan Chak wrote 1 year ago: I got a lot of great feedback on my tutorial at PGCon. The slides, as well as a sample chapter from … more →
Interviewing: The difference between Delete and Truncate in Oracle
— 22 comments
David Aldridge wrote 1 year ago: I interviewed a couple of senior ETL developer candidates last week, so I shook the dust off of some … more →
Fast Refreshable Materialized Views
— 5 comments
S wrote 2 years ago: Not many people, including a few reasonably smart ones, understand how exactly materialized views wo … more →
Back to a More Simple Time
— 13 comments
David Aldridge wrote 2 years ago: If we browse the Oracle Data Warehousing Guide we find a number of interesting database structures a … more →
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 →
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 →
The Mysterious Benefit Of Completely Redundant Materialized Views
— 4 comments
David Aldridge wrote 4 years ago: A Scenario You've just started working on a new data warehouse project, and you're familiari … more →
Optimizing Materialized Views Part III: Manual Refresh Mechanisms
— 9 comments
David Aldridge wrote 4 years ago: So, back on the subject of fast-refreshing multiple materialized views. Reviewing my previous commen … more →
Optimizing Materialized Views Part I: Principles For Analysis
— 6 comments
David Aldridge wrote 4 years ago: Some Background For a variety of reasons that are too painful to relate, query rewrite against some … more →
