Nitin Deshmukh

• Nov 22nd, 2005

 

Materialised view is the view that is physically present in the databse.

soji

• Jan 20th, 2006

 

The materialized view is a table whose contents are periodically refreshed using a query against a remote table.

samba

• Feb 5th, 2006

 

it stores the out put of the query . here no data consistence .

Deep Chandra Pandey

• Mar 28th, 2006

 

Since when we are woring with various databases running in different system,So sometime we may needed to fetch some records from the remote location,so it may quit expensive in terms of resourse of fetching data directly from remote location.To to minimize to response time and to increse the throughput we may create the copy to that on local database by using data from remote database.This duplicate copy is Known as materialised view,which may be refreshed as per as requirment as option avilable with oracle such as fast,complete and refresh.

Renu

• Jan 26th, 2007

 

Materialized View stores both - definition of the view and rows resulted from execution of the viewMain disadvantage of materialized view is that, its contents get outdated when underlying base table is modified .U can refresh Materialized View using DBMS_MVIEW.REFRESH

nambiaruran

• Jun 29th, 2007

 

Materialised view contain data of last refesh database but incase of view it stores only complex sql statement. Whenever your refresh the database the data will update on the materialised view, so its very quick to retrieve data.

msabuu

 Profile Answers by msabuu 

• Nov 12th, 2007

 

Materilised views are object, that are redused set of information sorting aggregatting from the base table, it's called materilised view.

subodhrnc

 Profile Answers by subodhrnc 

• May 19th, 2008

 

A materialized view (MV) is similar to a view but the data is actually stored on disk (view that materializes). Materialized views are often used for summary and pre-joined tables, or just to make a snapshot of a table available on a remote system. A MV must be refreshed when the data in the underlying tables is changed.

shanitha

• Sep 11th, 2012

 

Materialized view is a database object that contains the results of a query..

thiru

• Jun 25th, 2014

 

Its a one of the oracle object,its physical storage on the disk then (dbms_refresh)