• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9546
  • Last Modified:

how to check index on oracle table

Dear All,

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


Thanks,
Priyashree
0
priyashree
Asked:
priyashree
2 Solutions
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now