khadarbasha

 Profile Answers by khadarbasha 

• Sep 30th, 2005

 

Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse.

A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data

ravi

• Oct 4th, 2005

 

view is a tailriad representaion of data,its access data from existing table,it have logical structure,cant space occupation.

but meterailzedview stores precaluculated data, its have physical structure, space occupation

ravikumar guturi

• Oct 4th, 2005

 

view is a tailraid representation of data, but metereialized view is stores precaluculated data, view is a logical structure but mview is physical structure, view is cant occupie the space bu mview is occpies space.

Sridhar

• Oct 5th, 2005

 

Diffence between View Materialized view

If you (Change) update or insert in view the corresponding table will affect. but changes will not affect materialized view.

prasad nallapati

• Oct 11th, 2005

 

materialized views to store copies of data or aggregations.Materialized views can be used to replicate all or part of a single table,
or part of single table, or to replicate the result of a query against multiple tables.refreshes of the replicated daa can be done automatically by the database at time intervals.

venk

• Oct 13th, 2005

 

A view do no derive the change made to it master table after the view is created.

A materialized view immediately carries the change done to its mater table  even after the materialized view is created.

manjunath

• Oct 27th, 2005

 

view- the select query is stored in the db. whenever u use select from view, the stored query is executed. Effectively u r calling the stored query. In case u want use the query repetadly or complex queries, we store the queries in Db using View.

where as materialized view stores the data as well. like table. here storage parameters are required.

kalavlag

• Nov 3rd, 2005

 

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.

swati

• Nov 4th, 2005

 

In materialized view we cann't perform DML operation but the reverse is true in case of simple view.

swati

• Nov 4th, 2005

 

In case of materialised view we can perform DML but reverse is not true in case of simple view.

ramesh yellelli

• Nov 11th, 2005

 

view - It is logical representation of data

M.View - it is physical representation of data we are using in DWH

bhaskar

• Nov 12th, 2005

 

View is store query. Materialized view is snapshot data of query. Materialized views data can be refreshed in diffrent ways. Indexes can be created on MVs not views

deepa madala

• Nov 15th, 2005

 

Materialized view is a data base object.

view is not a data base object.

ravi guturi

• Nov 16th, 2005

 

view is a structure, access some original table.but mview is stores precaluculated data.

jaya

• Nov 18th, 2005

 

Materialized view contains data which was already fired on base tables, so  performance will be increased at the time of retreiving records.

Vies are different types like simple view, complex view..

Whenever u fire a query on  views, the data will be fetched from the  base tables of the view  and then give ur output.

ravi guturi

• Nov 25th, 2005

 

view is a structure , we access the data from table

m.view is used to precaluculated data,

view is logical representation.

m.vies physical representation.

view can not occupice space

m.view occupies space

amitbagaria

 Profile Answers by amitbagaria 

• Mar 1st, 2006

 

Views contains query whenever execute views it has read from base table

Where as M views loading or replicated takes place only once which gives you better query performance

 

Refresh m views 1.on commit and 2. on demand

(Complete, never, fast, force)

 

Sachin

• Mar 1st, 2006

 

For a large database, a materialized view may offer several performance advantages. Depending on the complexity of the base SQL, you may be able to populate the materialized view with incremental changes (via a materialized view log) instead of completely re-creating it during data refreshes.Unlike snapshots, materialized views can be used dynamically by the optimizer to change the execution paths for queries. This feature, called query rewrite, enables the optimizer to use a materialized view in place of the table queried by the materialized view, even if the materialized view is not named in the query. For example, if you have a large SALES table, you may create a materialized view that sums the SALES data by region. If a user queries the SALES table for the sum of the SALES data for a region, ORACLE can redirect that query to use your materialized view in place of the SALES table. As a result, you can reduce the number of accesses against your largest tables, improving the system performance.

sdfsdf

 Profile Answers by sdfsdf Questions by sdfsdf

• Mar 24th, 2006

 

in view we can perform update and delete operation only which will reflect in master table. view doesn't contain any data so its not occupying any space.

but materialized view contain data because it is the replication of the master table.in which we can perform DML operation. the changes made in M.view is reflected back to master table.

vijay

• Jun 12th, 2006

 

Meterialized views are phisical oracle database objects. Using these we can refresh database tables (W r t) timely manner.

whereas views are logical database object.if any chages happens in tabl those changes will effect that respective view also.

This is major diff.

If any inf. please let me know.

Thanks.

Shekhar Pandit

• Sep 15th, 2006

 

DMLs can be used against view (if they are based on 1 table with no aggr funs)

pkshve

 Profile Answers by pkshve 

• Sep 13th, 2010

 

View is just a SQL statement stored in Database which is executed every single time its called.

Materialized view (MV) is SQL statement and its resultant data stored in database in some form - eg in temp tables while its created.
This help in faster extraction of data - downside is the MV has to be refreshed in regular basis to get latest data.