Re: partitioned index does not work.

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 17 Jul 2002 13:32:27 +1000
Message-ID: <os5Z8.36476$Hj3.110518@newsfeeds.bigpond.com>

Hi Bernard,

A bit more information is needed such as type of partitioned index (local/global, prefixed/non prefixed), number of partitions, CBO or RBO, ...

ONE possible reason is that you are using a LOCAL non prefixed partitioned index with a significant number of partitions. In order for Oracle to process your query with the index, it might have to read ALL your local index structures which the CBO is viewing as being too expensive.

There are a lot of if and buts with this one.

One final tiny little point. Any particular reason for the set of parenthesis around the first AND condition ?

Richard

"Bernard S.J.Situmeang" <bermar_at_wanadoo.nl> wrote in message
news:zO_Y8.10190$zz6.145755_at_castor.casema.net...

> Help me..please....
> I have created a partitioned index ( consists of 4 columns:degebjr,
degegjr,
> deiouce, deinece ), degebjr is leading.
> - If i do use this following select statement , why does the statement not
> use the partitioned index ?.
> - If i don't create a partition, how come the statement does use the index
> ?.
>
> statement:
> select doinece into :b0
> from drfusie
> where (( degebjr = :b1 and degegjr = :b2) and deiouce = :b3)
>
> regards,
>
> Bernard Situmeang
>
>
>
>
Received on Tue Jul 16 2002 - 22:32:27 CDT