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

From: Jonathan Lewis <>
Date: Sun, 8 Jun 2008 15:19:10 +0100
Message-ID: <>

<> wrote in message

>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
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.



Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Sun Jun 08 2008 - 09:19:10 CDT

Original text of this message