Re: FTS on small Materialized View, should I cache it in the KEEP Pool ?
Date: Sun, 8 Jun 2008 15:19:10 +0100
<krislioe_at_gmail.com> wrote in message
>Thank you for your reply.
>>you are allowed to create indexes on the tables that sit under
>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
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.htmlReceived on Sun Jun 08 2008 - 09:19:10 CDT