Index usage tracking
Does someones know an easy way to check if an index is used or not ?
We have lots of indexes, using lots of space but I want to check if all of them are used. There is always the possibility to put the database in trace mode and to analyze traces after but it is quite heavy and time consuming. SO if someone has a better idea .....
sure, if you are in 9i you can
For more info on 'index monitoring' in 9i, check this link.
This was discussed recently - some ideas in this link for 8i, but no solution as such.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Click Here to Expand Forum to Full Width