Which Refresh mode is better in my case
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Which Refresh mode is better in my case

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'd bet the fast refresh would be better. Why don't you test it and let us know the results.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Posts
    315
    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
  •  


Click Here to Expand Forum to Full Width