Re: Oracle views clarification

Teresa wrote:

> Hi
>
> Can someone please explain the difference is between an Oracle dynamic
> view & materialized view.
>
> Thank you
> Teresa

Materialized views are tables refreshed by a trigger. They can be indexed and in all other ways treated like a table such as creating statistics for the optimizer.

Views are basically SQL statements wrapped with a ribbon and stored in the database.

You will find all of the information at http://tahiti.oracle.com. Search for views and materialized views and look at the concepts books.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)