how to check index on oracle table

Dear All,

   kindly give me the query to check the index  for the oracle table........


Thanks,
Priyashree
priyashreeAsked:
Who is Participating?
 
Helena Markováprogrammer-analystCommented:
select * from sys.user_indexes t where t.table_name='your_table';
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I would prefer DBA_INDEXES, as USER_INDEXES is only for the connected user's own indexes...
http://www.ss64.com/orad/DBA_INDEXES.html
also, which columns are actually indexes:
http://www.ss64.com/orad/DBA_IND_COLUMNS.html

CHeers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.