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!

Need query to find out whether exactly 2 columns are used in any index ?

Sh...Dec 17 2012 — edited Dec 26 2012

Suppose i have two columns ID and Status (or any number of columns ) belongs to table customer...

Now I want to create below index

Ex. create index test1 on customer (ID , Status )

But before creating this index i want to check that whether there is already index on these 2 columns ? May be by other name ?

Need query for this.

Plz help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2013

Added on Dec 17 2012

#general-database-discussions, #index

23 comments

1,289 views