ProAnswers.org

How to see all the indexes created on a particular table?

To see all the indexes created on a particular table you need to query all_indexes specifying the name of the table of interest as follows:

SELECT index_name FROM all_indexes WHERE table_name = 'EMP';