How to know which index a table is using?
A. SELECT table_name,index_name FROM user_constraints
B. SELECT index_name FROM indexes
C. SELECT table_name,index_name FROM user
D. SELECT table_name FROM indexes_tables
Answer:A
How to know which index a table is using?
A. SELECT table_name,index_name FROM user_constraints B. SELECT index_name FROM indexes C. SELECT table_name,index_name FROM user D. SELECT table_name FROM indexes_tables