Determine Indecies for a database

Looking for code that will display all indexes use in a Oracle Sql database?

Thanks,

Karen
Karen SchaeferBI ANALYSTAsked:
Who is Participating?
 
Bill PrewCommented:
If you mean "defined" rather than "used", then you can do something like either of these.  ALL_INDEXES is restricted to what the current user can 'see', DBA_INDEXES should be all indexes as long as you have access to that.

SELECT * FROM ALL_INDEXES;
SELECT * FROM DBA_INDEXES;



»bp
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
Thanks that did the trick
0
 
slightwv (䄆 Netminder) Commented:
I realize you've already closed this but I would suggest USER_INDEXES while logged in as the schema owner.  Otherwise you will get a LOT of stuff that likely isn't relevant.
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.