Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> partitioned index does not work.

partitioned index does not work.

From: Bernard S.J.Situmeang <bermar_at_wanadoo.nl>
Date: Tue, 16 Jul 2002 19:50:55 GMT
Message-ID: <zO_Y8.10190$zz6.145755@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 - 14:50:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US