>Hi Bruce,
>
>While he didn't say it, I read Doug's to mean 'horribly fragmented'
within the table, negating the COPY TO with ORDER set that was intended to optimize it in the first place.
>
>Cheers,
>
>Jim n
>
>>>I respectfully disagree. Packing the table at that point will provide for further fragmentation. Defragging the disk will cause the table to become contiguous and because you are not shrinking and growing the table it will remain contiguous indefinitely.
>>
>>I don't think it's much of an issue any more whether you PACK or not with the new software available - we run Diskeeper to defrag our servers nightly...
Jim,
Mercy buckets (a little French longo there *g*).
I did indeed mean internal fragmentation. Sorry I wasn't as clear as I should have been.
Best,
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.