Submitted Questions

  • Apr 30 2006
    04:05 PM
    30233
    27

    What is the difference between snapshot & materialized view ?
    • pandish

    Snehal

    • Jul 10th, 2012

    View : View exists logically.Its a virtual table.Whenever we are firing a query on a view we are getting a data from a table. But for a snapshot it is not a case... snapshot itself store a data.. refr...

    ravinder lathwal

    • May 15th, 2012

    Snapshot is just like print screen. or materialized view is actual table.
    snapshot is read only.you will find it same stage every time.
    but materialized view is update mode.always you will find it a new stage.