Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fast refresh VS Complete refresh

NunoOct 6 2009 — edited Jun 27 2013

Hello Oracle users

I'm using materialized views to replicate data from one BD to another. Basically is a subset of data, based on a date (for instance, records from less than a year ago), and without all the columns (master table has 10 cols, replica has 5, for example).
I know that fast refresh is better for small amounts of data, but my question, as stupid as it may seem is: what is "small amounts"? 100 records? 1000? 10000?
This is constraining the type of refresh i'll use; the complete one takes a while, but aparently the fast will be worse. By the way, the table in question takes a few thousand rows each day...

thank you for any help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2013

Added on Oct 6 2009

#database-key-features, #replication

3 comments

16,957 views