Post reply

Does a database shrink rebuild ALL indexes?

  • May 22, 2003 at 8:27 am

    #64849

    Does a database shrink rebuild ALL indexes inlcuding primary keys?

    Thanks.

  • May 26, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • May 28, 2003 at 2:12 pm

    #458910

    Not that I am aware of. The shrinking of the database as far as I know, reduces the size of the files in the database. I am not aware of any rebuilding.


    "Keep Your Stick On the Ice" ..Red Green

  • May 28, 2003 at 2:29 pm

    #458914

    No, It doesn't rebuild any indexes.

  • May 28, 2003 at 2:30 pm

    #458915

    Don't think so!

  • May 28, 2003 at 11:55 pm

    #458949

    No, it doesn't . First use DBCC DBREINDEX or rebuild your indexes manually after then shrink your db

  • May 29, 2003 at 4:38 am

    #458966

    There are a comple of shirnk methods such and truncate free space and such but none do any index rebuilds and as Cengizu notes do your rebuilds befor shirnk as these will cause and size increase while the rebuild is done.

Viewing 7 posts - 1 through 6 (of 6 total)

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