REMOVING UNUSED INDEXES

greenspun.com : LUSENET : DBAzine : One Thread

MY DATABASE IS ORACLE 8i (Oracle8i Enterprise Edition Release 8.1.7.0.0 ).I HAVE LARGE NUMBERS OF UNUSED INDEXES.

1)ARE THERE ANY DATA DICTIONARY VIEWS WHICH COULD HELP ME TO MONITOR THE USAGE OF INDEXES.

2)DO SUGGEST ME HOW I COULD IDENTIFY THE UNUSED INDEXES-I NEED TO DROP THEM.

THANX FOR ALL SUGGESTIONS

-- Raghavan Radharamanan (RRCVELOCITY@YAHOO.COM), September 13, 2003

Answers

Use the command "alter index index_name monitoring usage" after that you check in select * from v$object_usage if the index is used.

to stop the index monitoring use : "alter index index_name nomonitoring usage'

Best regards. Mourad

-- mmek mmek (mmek@boursorama.com), January 18, 2005.


Moderation questions? read the FAQ