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

Thread: Materialised View

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    I am using the Materialised view in a table which calculates the summary info of that table.
    The updation rate of the table is 60 records/minute

    Materialized view is scheduled for every one hour.
    I want to know whether the updation speed will slow down during the view refresh every one hour

    Do the refreshing of materialised view affect the table updation.
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    You might use option refresh fast on demand. it will make light impact on your table.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

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