Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Composite index vs Single column index

HesipesiDec 11 2015 — edited Dec 16 2015

Hi,

I have a table with a,b,c,d,e,f,g,h,i,j,k. columns and i have an index on a,b columns!

There is a sql statement now with where a= ? and we are wondering if it could also be good to add a single index on just 'a' column!

doesn't help AT ALL? it does help in SOME CASES? or???

what do you think??

Thanks!

/Hesi

This post has been answered by Jonathan Lewis on Dec 14 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2016

Added on Dec 11 2015

#general-database-discussions

10 comments

50,793 views