Oracle 11g: Get a list of all Indexes defined for table/schema

This is how you can get a list of all indexes defined on a particular table or the number of indexes on tables inside a particular schema.

For a particular table,

SELECT * FROM ALL_INDEXES WHERE TABLE_NAME='YOUR_TABLE_NAME'

For a particular schema,

SELECT * FROM ALL_INDEXES WHERE TABLE_OWNER='YOUR_SCHEMA_NAME'