Re: a heated discussion between Development Team & "a" DBA: reorg or not to reog

OldDBA wrote:

> Rebuild Indexes - Indexes get fragmented very easily with a lot of
> delete's going on. In addition, they will also grow uncontrollably
> since Oracle does not reuse the space occupied in an index after a
> delete.

Oh God! Please, don't say this...

> everything else combined. If you can show the developers (and the
> business) the error of their ways, you will become the hero, gain
> considerable credibility and shut down the naysayers in the process.

Or the enemy, because now they'll be considering you as a threat to their all-covering "knowledge of the application". Received on Thu Jun 23 2005 - 22:43:59 CDT