Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to force index usage ?

2844860Jul 1 2009 — edited Jul 1 2009
Hi,

I have a column which is index but nonunique.

when i used this column in where cluase with 'IN' the index is not being utilised.
As i was searching for information, i came across that oracle skips the index if we use 'IN'.

is there any workaround to make this work?

Thanks
knick
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2009
Added on Jul 1 2009
6 comments
757 views