Re: Index maintenance...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 5 May 2004 13:06:40 +0200
Message-ID: <c7ahs0$l2i$1@nntp.fujitsu-siemens.com>

"Howard J. Rogers" <hjr_at_dizwell.com> schrieb im Newsbeitrag news:4098c22d$0$6018$afc38c87_at_news.optusnet.com.au...
> It is always possible you've got a rogue index and that a rebuild might
> result in a measurable performance boost. It is, though, rather
> unlikely. In general, indexes don't need rebuilding, and doing so
> doesn't improve performance. In general, that is.
Yup. The guy (and we too) are unusual in that we do lots of inserts, deletes and inserts again because we are debugging an app that uses the db.

> Without benchmarks to prove the point, I would think that wishful
> thinking is what is actually behind it.
Ok.
>
> Without benchmarks, the assertion by your consultant is meaningless.
We'll check it out on out environment.

Lots of Thanks!
Volker Received on Wed May 05 2004 - 06:06:40 CDT