kalpana

• Dec 19th, 2006

 

A view is just a stored query and has no physical part. Once a view is instantiated, performance can be quite good, until it is aged out of the cache.

A materialized view has a physical table associated with it; it doesn't have to resolve the query each time it is queried. Depending on how large a result set and how complex the query, a materialized view should perform better.

Tanveer

• Dec 19th, 2006

 

View-> Using View in Select Statement will always return the upgraded information..

Materialized View-> On Running Select Query Recent data available on the timing of Refresh clause mentioned while create Materialized View.

Materialized view were earlier called Snapshot.

Jirange

 Profile Answers by Jirange 

• Oct 15th, 2008

 

View is a replica of table.
Materialized  view is remote table on local database.

gautthamm

 Profile Answers by gautthamm 

• Dec 31st, 2008

 

After update of the table, the view automatically gets synchronized where as the Materialised view needs an explicit refresh (either Manual or by Oracle) for synchronisation.

Another diff is that the rowids of the table and view matches, whereas the MV's row ids and the table's rowids will differ, thus indicating that the MV returns a completely different physical location of the table data.