At some point on here there was a discussion about index rebuilds good vs bad. If I remember correctly Slimdave at one point said that normally indexes shouldn't be rebuilt for anything other than moves and such. I've also read on Toms site that some indexes perform better "fat". which I totally agree from experience
I've come in contact with someone who seems to think that indexes need to be rebuilt on a monthy basis no matter what and I'm trying to gather up documentation to prove to this person that this is not a good idea. My experience and findings mean nothing to this "know it all" and I want to show this person that Oracle has evolved and the DBA community out there has proven that this is not a good idea.
I personally use Richard Niemiec's advice using binary hieght as a means to gauge "fragmentation"*. If the b-level goes over 4 I rebuild em.
* The amount of I/O that needs to be peformed to return the rowid to the user process.
let the gates open for discussion!