Hi :

Still having a problem...Don't know what do to?

a) When you say "uses an index", do you mean a local or global index ?
=> Local Index...

b) Is the index quite selective ?
=> Yes

c) Do the two partitions have roughly the same amount of data ?
=> Yes. Also, I tried with deleting the records.. Did not help much..

d) Is it a bitmap index or a btree index ?
=> btree

e) Have you analyzed the table as a single unit or have you analyzed each partition separately ? Have you done a "for all indexed columns" to get the histogram data ?
=>Analyzed each partition separately..

Thanks.