Re: FTS on small Materialized View, should I cache it in the KEEP Pool ?

<krislioe_at_gmail.com> wrote in message
news:69dda8b0-da20-4b0d-9e07-9038745b6dcb_at_t12g2000prg.googlegroups.com...

>Hi,
>Thank you for your reply.
>
>>you are allowed to create indexes on the tables that sit under
>>materialized views
>What dou you mean that that ?
>
>Doesn't the running query access the MV itself, not the base table ?
>
>So what is the benefit of creating index on its base table ?
>

A materialized view is defined through a select statement:

create materialized view xxx
as
select ...

This results in the creation of an object of type "materialized view" called XXX and an object of type table calls XXX. My reference to a table "under the materialized" view was about the table XXX, not to any of the tables in the select statement.

--

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html