Home » Server Options » Replication » Materialized view complete refresh
Materialized view complete refresh [message #249222] Tue, 03 July 2007 12:21 Go to next message
jawi
Messages: 3
Registered: July 2007
Junior Member
Hi,

I have a number of materialized views on a fact with just a few hundred million rows (it will have more than 15 billion in the future). The time it takes to completely build the views, is about 11 hours for each (we then use PCT and FAST refresh for new data, which in test work fine). My question is: if we ever change a detail table (add a column for example) then the materialized views will need to be rebuilt with a complete refresh, which will be a very long time. Is there a way of constructing the views such that the build time will be much less and query rewrite will use them?

Thanks

James
Re: Materialized view complete refresh [message #249227 is a reply to message #249222] Tue, 03 July 2007 12:37 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
may this help you.
Previous Topic: Replication
Next Topic: About Suppliment Logging
Goto Forum:
  


Current Time: Thu Mar 28 06:54:47 CDT 2024