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

Thread: materialize view

  1. #1
    Join Date
    Jan 2001


    can anyone explain what is a materialize view?
    is it a 8i feature or does it exist before?


  2. #2
    Join Date
    Sep 2000
    Materialized views are used mostly on big tables,partition tables dss applications .

    On big tables when you want max,min,average ,sum of certain values it takes a lot of times.

    with Materialized views these things can be done pretty fater.

    Materailazed views gater these datas and keep them on a snapshot. so when a querry asks sum(sal).

    it takes the value from snapshot and gives the information.
    Rather than sum all the values when the querry is proccessed.

    pls look for more information on manuals.


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