Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> partitioned index does not work.
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