Re: Partition Views

From: Atul Ashar <aashar_at_usccmail.bms.com>
Date: 1997/07/09
Message-ID: <33C3F17F.5238@usccmail.bms.com>#1/1

You can create index on tables for performance as well as RI and Oracle will use it if it is beneficial. It is also suggested that you create index on column on which you have partitioned views.

JP Soria wrote:
>
> We would like to set up our database using partition views, 2 views with
> 48 partitions each. My understanding is that you cannot have an index on
> a view so would we have to index the tables individually ? Or by using
> partition views do we bypass having to use any indexes?
Received on Wed Jul 09 1997 - 00:00:00 CDT