Sheela

• Sep 7th, 2005

 

Materialized view is like a view but stores both definition of a view plus the rows resulting from execution of the view. It uses a query as the bases and the query is executated at the time the view is created and the results are stored in a table. You can define the Materialized view with the same storage parametes as any other table and place it in any tablespace of your choice. You can also index and partition the Materialized view table like other tables to improve performance of queries executed aginst them.  
 
Use of Meterialized view:- 
 
Expensive operations such as joins and aggregations do not need to be reexecuted. 
 
If the query is astisfied with data in a Meterialized view, the server transforms the query to reference the view rather than the base tables.

paparao03@gmail.com

• Oct 27th, 2006

 

I am agree with above(sheela) comments.

along with It is more usedful OPTIONS LIKE FAST, COMPLETE, FORCE, WITH THE HELP OF MATERIALIZED VIEW LOG IS MORE USEFUL.

paparao03@gmail.com

• Oct 30th, 2006

 

Query Rewrite option advantages we can get with the materialize view option also.