What is Materialised View?

Editorial / Best Answer

Answered by: 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

Showing Answers 1 - 22 of 22 Answers

Nitin Deshmukh

  • Nov 22nd, 2005
 

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

  Was this answer useful?  Yes

soji

  • Jan 20th, 2006
 

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

  Was this answer useful?  Yes

samba

  • Feb 5th, 2006
 

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

shanitha

  • Sep 11th, 2012
 

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

  Was this answer useful?  Yes

thiru

  • Jun 25th, 2014
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions