I don't have first hand experience with 9i in a production setting yet,
but the problem I see with using v$segment_statistics as well as using
v$bh (as touted in "Is the index still being used ?") in determining
used/unused indexes is that an index presence in those views does not
necessarily indicate that the index in question is actively being used
in sql plans. They could just be there because they need to be
maintained as a result of DML on the row(s) they index. So it could
still be just dead weight.
--
Posted via http://dbforums.com
Received on Wed Jun 04 2003 - 11:52:56 CDT
