Home » RDBMS Server » Performance Tuning » How can I tell if an index is working?
How can I tell if an index is working? [message #365458] Sun, 21 June 1998 19:18 Go to next message
Tom Womack
Messages: 1
Registered: June 1998
Junior Member
I am working in a tablespace containing approximtely 250 tables. All of these have indexes. Typically I have found that the tables user_cons_columns and user_constraints contain info related to a tables index. The tables contain no information on indexes. How can I tell if the indexes are actually working?

Thanks,

Tom

Report message to a moderator

Re: How can I tell if an index is working? [message #365461 is a reply to message #365458] Mon, 22 June 1998 10:46 Go to previous message
J Testa
Messages: 1
Registered: June 1998
Junior Member
you can use explain plan for specific SQL statements to see if the index is being used.

joe
http://www.oracle-dba.com

Report message to a moderator

Next Topic: How can I tell if an index is working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 09 20:35:37 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.