Re: Oracle8 partitions and joins question.

Hi,

There will be some cost in performing the 'partition elimination' portion of the SQL execution path, but this will not be to painful, and a lot less painful than scanning the data blocks associated with a smaller number of partitions.

I am not to sure about the partition index, but I do believe that you will be able to use parallel query to number crunch your way through with the local index.

Rgds
Andrew

Prasanth Duvvur wrote:

> Hi,
>
> Background: I have a 20 gig table that will have 65-99 partitions, I am
> planning on using the primary key of the table to serve as the partition
> key. For indexing I am planning on creating local partitioned indexes
> (for partition elimination).
>
> Question: Will queries that involve a join to this table from another
> table, be unduly affected by the number of partitions? Also will the
> optimizer perform OK with a local partition index as opposed to a global
> partitioned for this situation?
>
> Thanks,
> Prasanth
Received on Thu May 13 1999 - 19:58:47 CDT