Post reply

DBCC INDEXDEFRAG fill

  • March 18, 2008 at 7:18 am

    #71719

    I have a huge table which needs reindexing but it has to be online so the only choice I have is INDEXDEFRAG.

    How do I specify a fill factor with INDEXDEFRAG?

    Many thanks

  • March 18, 2008 at 7:45 am

    #790821

    Edward,

    Unfortunately you cannot specify a new fill factor for an index during a defrag operation. You'd need to to a rebuild for that.

    Karl
    source control for SQL Server

  • March 18, 2008 at 11:14 am

    #791004

    You can change the value of OrigFillFactor column in sysindexes table for that particular index. You have to change it before executing DBCC INDEXDEFRAG.

    SQL DBA.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply