Cry How To...
List all the indexes for a table
To list all the indexes for a table:
select index_name from user_indexes
where table_name = 'TABLE_NAME';
be aware that case is significant and that table names are in upper case.
If the table is a system table then it will not be listed in the
user_indexes
view, so instead use all_indexes
:
select index_name from all_indexes
where table_name = 'TABLE_NAME';
This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.