none
index with a large fragmentation

    Question

  • I have several index with a large fragmentation value. An example is this:

    Database,Index,Table,Size (pages),Fragmentation %
    PROD,IND_01,VSIFTIDX,8,87

    I execute the command (ALTER INDEX [IND_01] ON [PROD].[dbo].[VSIFTIDX] REBUILD WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = OFF);)  but it does not decrease the fragmentation. Do I do something wrong?

    SQL 2008 R2 SP3 - STANDARD

    Sunday, April 30, 2017 6:16 PM

All replies