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!

Re: Composite Index Order - Performance

rcc50886Aug 9 2012 — edited Aug 10 2012

All,

We have a table and we need to create a composite index on three columns. see below:

Column Distinct Values
XX 3
YY 1500
ZZ 42207

All three columns will be used in WHERE clause in all the SELECT sql's. So what is the best index order in means of performance perspective ??

Can some one explains me how and why ??

-Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2012

Added on Aug 9 2012

#general-database-discussions

29 comments

4,401 views