SELECT index_name FROM user_indexes WHERE table_name='EMP';For all indexes that are returned, issue the following:
ALTER INDEX index_name MONITORING USAGE;After exercising your application, query the V$OBJECT_USAGE view. The USED column of this view will contain YES if the index was used; otherwise, it will contain NO. This will tell you if the index has ever been used since the MONITORING USAGE command was last given.
If you are not using indexes, drop them. When done, you can turn off monitoring with the following:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
ALTER INDEX index_name NOMONITORING USAGE;
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.