How to know which index a table is using?
SELECT table_name,index_name FROM user_constraints