| Materialized view complete refresh [message #249222] |
Tue, 03 July 2007 12:21  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
