Post reply

Which Task in maintenance plan does the Index rebuilds in SQL Server 2000?

  • June 26, 2009 at 5:32 pm

    #72240

    hi,

    I'm trying rebuild indexes using maintenance paln in sql server 2000. For this which task I should Use?

    thanks

  • June 26, 2009 at 7:11 pm

    #1016322

    Itd under second tab(Optimizations).

    From BOL:

    Reorganizing the data on the data and index pages by rebuilding indexes with a new fill factor. This ensures that database pages contain an equally distributed amount of data and free space, which allows future growth to be faster. For more information, see Fill Factor.

    MJ

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

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