How do you know which index a table is using?

  • Interview Candidate
  • 21
  • 6530

Showing Answers 1 - 21 of 21 Answers

Guest

  • Jan 11th, 2007
 

Execute bellow query.you can get details of INDEX NAME with TABLE NAME.

SELECT * FROM user_constraints

raj

  • Jan 31st, 2007
 

select index_name,index_type,table_name,column_name from user_indexes,user_ind_columns;

  Was this answer useful?  Yes

Radhi

  • Feb 15th, 2007
 

select table_name,index_name from user_constraints;

Imran_Javed

  • May 9th, 2008
 

SELECT
  ui.INDEX_NAME,
  ui.TABLE_OWNER,
  ui.TABLE_NAME,
  ui.TABLE_TYPE,
  uic.COLUMN_NAME
FROM
  USER_INDEXES ui ,
  USER_IND_COLUMNS uic
WHERE
  ui.table_name = uic.table_name  AND
  ui.table_name ='EMP';

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions