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!

About composite index

544878Jul 30 2007 — edited Jul 30 2007
Hi,

The composite index was built by our oracle DBA like this below as an example.

composite index - (a,b)
composite index - (a,c)
composite index - (a,d)
composite index - (a,e)

I have used the column "a" in where clause. the optimizer is not taking the index while fetching the records. Could you please explain what are the possible reasons, not using the index?

-Sathya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2007
Added on Jul 30 2007
6 comments
316 views