DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: materialized view question

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai,

    I am creating a materialized view and also mview log with force option.

    Will this option use the materialized view log to perform incremental refresh ?

    As far as it traced the queries during refresh, it didn't use the log.But is it true.
    Will the force option use the log.
    I cannot use the fast option because mine is a complex query
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if it's not fast you cannot do incrmenetal refresh
    force will do what it can not what you think

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