Which Refresh mode is better in my case

[ligang]

For a table with 1,000,000 records and the daily changes to the table
might be 10,000 records.

Try to sync this table by using materialized view .

Under this case , Which refresh mode is better to be choosed ?
Fast or Complete ?

Initially I thought Fast Refresh is better but now I am quite confused actually . Because I think to search 10,000 in 1,000,000
one by one might be more cost than a complete replacement?

Best Regards

LiGang

[marist89]

I'd bet the fast refresh would be better. Why don't you test it and let us know the results.

[lgaorcl]

If fast refresh works for the MV, it's better. Fast refresh is incremental, applying the change to the MV. But fast refresh has much more restrictions. You have to create logs for each base table.