Skip to Main Content
Forums

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!

Composite Indexes on same columns with different order.

AleCJul 15 2011 — edited Jul 15 2011
RDBMS: 11Gr2

I've created a new table with two new indexes:
create table drop_me (col1 number, col2 number);
CREATE INDEX INDEX1 ON DROP_ME (COL1, COL2);
CREATE INDEX INDEX2 ON DROP_ME (COL2, COL1);
The difference between the two indexes is the column order.

Is the second index redundant? Could it be useful?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2011
Added on Jul 15 2011
#11g, #general-database-discussions, #index
8 comments
434 views