Which Refresh mode is better in my case
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?