IDing unsed indexes?

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Wed, 24 Nov 1999 17:42:04 GMT
Message-ID: <81h81c$3uo$1@nnrp1.deja.com>

I am supporting a PeopleSoft application (AP & GL). There are a large number of indexes that have been added for "performance" purposes, I would like to have some method to help monitor what indexes are used. The database instance is set for CHOOSE and we calculate the statistics weekly for the tables.

I saw a reference to X$BH table that might help identify the indexes that are used. (I would need to monitor this and capture what was found in the buffer over time.)

I would like to minimize the number of indexes that are there and remove those that are not used.

Is there some documentation on the X$ tables, or some other technique (other than tracing all jobs) that would help monitor the index usage.

TIA
James

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 11:42:04 CST