How to identify unused indexes in the oracle DB 8i

greenspun.com : LUSENET : DBAzine : One Thread

DROPPING UNUSED INDEXES

MY DB SERVER IS ORACLE 8i(Oracle8i Enterprise Edition Release 8.1.7.0.0 on unix ).

I HAVE BEEN PLANNING TO DROP ALL THE UNUSED INDEXES FROM DBSCHEMA.

COULD ANYONE SUGGEST ME HOW TO LIST OUT ALL THE UNUSED INDEXES.

THE EXPLAIN PLAN & THE CBO OF 8i SHOWS THE INDEXES THAT ARE BEING USED ,HOW AM I TO LIST OUT THE UNUSED INDEXES IN THE DB SCHEMA.

THANX

-- Raghavan Radharamanan (raghavanr@cvelocity.com), September 11, 2003


Moderation questions? read the FAQ