Rebuilding a pk index

  • I have a huge table (270 million records, 118 GB). I need to rebuild its PK index because it is too fragmented. Problem is that I don't have enough of space for that. The transaction log will explode. Is there any trick that I can use?

  • I believe you could do a REORG

  • I think I heard something like if it is more than 50% fragmented, then it has to be rebuilt. If Reorg will do its job, I will do that.

  • chulheekim (12/11/2014)


    I think I heard something like if it is more than 50% fragmented, then it has to be rebuilt. If Reorg will do its job, I will do that.

    It might be suggested to do a Rebuild, but it does not have to be a Rebuild.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Thank you all.

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

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