vvijaychandra

 Profile 

• Jul 4th, 2006

 

A materialized view is a database object that contains the results of a query. They are local copies of data located remotely or used to create summary tables based on aggregation of a tables data. Materialized views which store data based on the remote tables are also know as snapshots.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

 

a materilized view can contain group function or some operators and it having some information . and it's useful in datawarehousing..