Ajeet Singh

• May 23rd, 2006

 

Snapshot is a copy of a table on a remot system but materialized niew is used to make a snapshot of a table available on a remote system.

dreadful scathe

• Jul 11th, 2006

 

A materialized view is the new name for Snapshot since Oracle 8i but 8i also introduced extra query rewriting functionality.

Manindra Kumar

• Oct 30th, 2006

 

What is the difference between snapshot & mat. vie...

raghu

• Jan 8th, 2007

 

snapshot and materialaized view are same, both stores the result of the query

dawood

• Apr 25th, 2007

 

The terms snapshot and materialized view are synonymous.
Both refer to a table that contains the results of a query of one or more tables, each

of which may be located on the same or on a remote database.
The difference is that snapshot is the word that is been used in oracle8i and materialized view is the one used in oracle 9i.

pramod

• Oct 22nd, 2007

 

Snapshot and materialized view are almost same same but with one difference.

You can say that materialized view =snapshot + query rewrite functionality

query rewrite functionality:In materialized view you can enable or disable query rewrite option. which means databse server  will rewrite the query so as to give high performance. Query rewrite is based on some prewritten standards(by oracle itself).So the database server will follow these standards and rewrite the query written in the materilized view..

but this functionality is not there in snapshots

siddhu

• Dec 19th, 2011

 

Snapshort and matrilised view both are same. Even we can proof by executing query. When you create snapshort we will get conform message saying that materailised view is created.

R Naresh Kumar

• Mar 18th, 2012

 

until oracle 8i it is called as snapshot,after oracle 8i it is called as materialized view....when we create a snapshot feedback will come as MATERIALIZED VIEW"..........When any changes in base table nothing will happen to materialized view.

priyank

• May 10th, 2012

 

Snapshots - are set of data pertaining to particular time, whereas Materialized Views are being used to have data with some Business logic

ravinder lathwal

• May 15th, 2012

 

snapshot is just like print screen. or materialized view is actual table.
snapshot is read only.you will find it same stage every time.
but materialized view is update mode.always you will find it a new stage.

Snehal

• Jul 10th, 2012

 

View : View exists logically.Its a virtual table.Whenever we are firing a query on a view we are getting a data from a table.
But for a snapshot it is not a case... snapshot itself store a data..
refreshing is der in a snapshot.

whenever refresh happens a data from its master table get updated into snapshot.

it refresh is not done and we are firing a select query on a snapshot it will show old data.

after refreshing only the data from table and snapshot will match.
Its not a cse for view.