Re: Oracle8 partitions and joins question.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 15 May 1999 07:36:41 +0100
Message-ID: <926750471.20973.0.nnrp-04.9e984b29@news.demon.co.uk>

Interesting point, neither of your samples shows a need for any secondary indexes.

Since in your case a prefixed secondary index is always going to be unique, I bet you end up with some non-prefixed indexes, and that they become a performance problem. Make sure you investigate thoroughly what secondaries you need and how this affects your physical design.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

>
>most queries will look like:

>from table
>table.partition_key = :value (only returning one record)
>
>there will be a report running once a night that will join with another
>table:
>from table, other_table
>table.partition_key=other_table.field (returning several records)
>
Received on Sat May 15 1999 - 01:36:41 CDT