How to know which index a table is using?

SELECT table_name,index_name FROM user_constraints

 

Author:

Since March 2011, have 8+ years of professional experience on software development, currently working as Senior Software Engineer at s3 Innovate Pte Ltd.

Leave a Reply