Re: fragmentation - a myth?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 17 Nov 1998 18:19:14 +0800
Message-ID: <36514DA2.2C6E@bhp.com.au>

benkrug_at_my-dejanews.com wrote:
>
> Hi gurus -
>
> Has anyone out there done tests to check the
> effect of fragmentation on performance?
>
> I wonder whether worrying about fragmentation
> is over-rated. Sure, if you have an old,
> fragmented table/index, and you rebuild them,
> performance is better. But how much of that
> is due to the index rebuild?
>
> Has anyone done timings to see how much
> performance improves when they
> (1) re-analyze the table
> (2) rebuild the index
> (3) de-fragment the objects?
>
> I'm going to do some myself soon.
>
> I know theoretically you reduce head
> movement, etc, but I wonder how much that
> matters these days.
>
> Any results would be very appreciated.
>
> Thanks,
>
> Ben Krug, DBA
> benkrug_at_yahoo.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

go to www.europa.com/~orapub...

some very good papers that explain

1. the fragmentation that you need to worry about
2. the fragmentation that you don't need to worry about

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Tue Nov 17 1998 - 04:19:14 CST