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 .....
03-19-2003, 04:25 AM
sure, if you are in 9i you can
03-19-2003, 04:31 AM
For more info on 'index monitoring' in 9i, check this link.