Post reply

Index Fragmenting

  • September 12, 2003 at 3:09 pm

    #59011

    DBCC Reindex & DBCC Indexdefrag

    I have my database on two files (but one file groups). My understanding is that when I creat a table and load data,

    it can be in either of the files. After a while, the table may be fragmented in both the files. Do either of the

    DBCC defragmenting commands (reindex or indexdefrag) transfer the data between the files while fragmenting?

    (My guess is they do not.. They only defragment within the file.. But would like to confirm)

    thanks.

  • September 13, 2003 at 2:34 am

    #474033

    BOL 2000:

    1) If there are multiple files in a filegroup, they do not autogrow until all the files are full. Growth then occurs using a round-robin algorithm.

    2) DBCC DEFRAGINDEX: If an index spans more than one file, DBCC INDEXDEFRAG defragments one file at a time. Pages do not migrate between files.

    3) DBCC REINDEX

  • September 16, 2003 at 9:57 am

    #474453

    Thanks for taking the time to answer.

    I agree with the first two. Regarding the third, I do not see any reference in BOL regarding REINDEX

    consolidating data into one file, when the file group consists of multiple files (though I find this a reasonable

    assumption, considering REINDEX recreates the index from scratch).

  • September 25, 2003 at 2:24 pm

    #475879

    DBCC DBREINDEX

    Terry


    Terry

  • September 25, 2003 at 2:25 pm

    #475880

    and DBCC INDEXDEFRAG

    Terry


    Terry

Viewing 5 posts - 1 through 4 (of 4 total)

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