Auditing Index usage

From: Iain Knowles <iain_at_rknowles39.freeserve.co.uk>
Date: Mon, 20 Mar 2000 23:39:50 -0000
Message-ID: <8b6csj$80m$1@newsg1.svr.pol.co.uk>

Does anyone know if it is possible to audit index usage on 8i.

I use a database, that has 6 main tables. The biggest table has approx 48million rows with approx 90 columns. There are other tables with between 18M and 30M rows. I have been asked to index every column in the six main tables. In my opinion less than 5% of the indexes would ever be used.

Is it possible to create a record of index usage that would prove my point. eg date of index last use, frequency of use etc

These indexes, as you can imagine are taking up an awful lot of space.

cheers

Iain Received on Mon Mar 20 2000 - 17:39:50 CST