DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Why we use materilzed view

    Hi All
    Can you tell me that why we use materlized view instead of Views.
    I know that in Mat View data is populated at the time of creation as not in case of View.
    Then what is the use of Mat view?


  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    I can think of three reasons, there may be more ...

    i) For replication, where we want to keep one database's data aligned with another

    ii) To provide a consistent view, by updating an MV at fixed intervals, like once a day.

    iii) To provide fast access to precomputed aggrege data.

    I expect other people can think of other reasons.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.