Discussion in 'SQL PL/SQL' started by somesh2011, Nov 2, 2014.
exact difference between view and Materialized view
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.
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.