Re: Episode 2: the EntMgr Green Light!!

"Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0311081901.60899479_at_posting.google.com...
> Guys,
>
> This is a bunch of BS. If your system is read-only most of the time,
> DSS, OLAP, then rebuilding your indexes after a huge load of data
> increases read performance -- don't tell me it doesn't. Smaller
> index, less I/O.
>
> Second, if the index starts growing again too quickly, the pctfree
> setting used on the rebuild was too low. The rebuild is not the
> culprit, you didn't use the correct setting. The base of the index is
> much better after a rebuild -- go write a b tree routine and you'll
> see for yourself.
>
> Geez, you guys make a mountain out of a mole hill. Thank God I'm the
> only DBA in my shop. Next thing you'll say it's not a good idea to
> index FKs.

dont you think you might be wrong if you are the ONLY person suggesting they are useful?

Open your eyes and realise you know know as much as you do.

Also if you rebuilt indexes on an application that I might sell you without asking me what the effect may be - then I might be rather annoyed at you. Secondly you could void suport contracts by hacking around someone elses application. Received on Sun Nov 09 2003 - 06:25:37 CST