[dba-SQLServer] Index Fragmentation

Arthur Fuller fuller.artful at gmail.com
Sat Jun 14 10:20:45 CDT 2008


Thanks for the info, Asger. That helps a lot.

Arthur

On Fri, Jun 13, 2008 at 9:31 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> Hi Arthur
>
> Short answer:
> A Page Fullness of 62.74% is normally OK.
> A Total Fragmentation of 71.67% is bad, and you should rebuild the index
> using the statement:
> ALTER INDEX myindex ON myschema.mytable REBUILD
>
> Elaborated answer...
>
>



More information about the dba-SQLServer mailing list