1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Materialized view

Discussion in 'SQL PL/SQL' started by somesh2011, Nov 2, 2014.

  1. somesh2011

    somesh2011 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    exact difference between view and Materialized view
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
  3. oliviathomas

    oliviathomas Active Member

    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    london
    hi friend i found this answer from internet

    Materialized views are disk based and update periodically base upon the query definition.

    Views are virtual only and run the query definition each time they are accessed.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    VIEWs are windows to data in the table(s) they reference. The benefit is the data is always real-time and can be a real time-saver for developers as they don't have to write the query. The downside of a view is the statement itself...depending on complexity the SQL performance of the view is problematic, i.e. it can be really, really, really slow.

    MATERIALIZED VIEWS (MV) are also windows to data in the table(s) they reference except the window is STATIC in that the data has already been retrieved. Thus a data query off an MV is very fast. The downside of the MV is the data can get stale. You have to setup the processes to refresh the data and the period rate you choose is entirely up to you.

    HTH

    CJ