| Situations where FAST REFRESH Materialized View does a COMPLETE REFRESH? [message #535622] |
Thu, 15 December 2011 06:03 |
tsteinmaurer
Messages: 12
Registered: October 2008
|
Junior Member |
|
|
Hello,
I have a regular table where I store aggregated values along the day granularity. I then have FAST REFRESH ON COMMIT Materialized Views for month and year. I can create the MV just fine, so the MV log should be fine, but I've read, even with FAST REFRESH there are situations where a COMPLETE REFRESH is done behind the scene.
I wonder, is there a pattern where a COMPLETE REFRESH is issued? While I would like to have the MVs up-to-date, thus the ON COMMIT option, I would like to avoid a COMPLETE REFRESH at commit time e.g. during the day.
Thanks,
Thomas
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
