Difference of view.
March 16, 2007 1:51am CST
What is the difference between a Materialzed view and normal view
• United States
13 Jun 07
MVIEW is like a regular view with the exception that it has a table like structure. You say it is a table created from a sql. MV requires refresh to get the latest data, it is basically a SNAPSHOT of data in time it is not real time. Regular view(RV) has to table like structure, it is an object created from a sql but only in definition it does not hold data like a table. RV does not require refresh, every time u select from an RV the data is real time. Regards Ashutosh (Oracle Dba)