Information générale
Catégorie:
Codage, syntaxe et commandes
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...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement