Hi,
A materialized view is an instantiation of a view that is stored like a
table and can have indexes created on it like a regular table. It can
however not be accessed by users. The optimizer determines whether or not
to use the view when it processes a complex view (select statement) based
on the features of the view. All you need to do is enable the use of the
view using the init.ora parameters. ex query rewrite, integrity of the
view, refresh method etc. You may need to read more on it before trying to
create one.
Sabina




"BRoussel" <oracledba-ezmlmshield-x17342744.[Email address protected]
10/31/2005 03:10 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Materialized Views










Hi DBAs,

I would like to use materialized views for a project that we are
thinking of, see below:

2 tables with 4.4 millions of rows each
Need to be read-only view
Run from Monday to Friday at 5:00am

It is my first time and I would like to have an example on how to
code this materialized view...

The environment is Unix Solaris and Oracle9i.

Thanks,

Bruno



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page