-
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?
Best Regards
LiGang
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com
-
I'd bet the fast refresh would be better. Why don't you test it and let us know the results.
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|