December 11, 2014 at 12:40 pm
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?
December 11, 2014 at 1:23 pm
I believe you could do a REORG
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 11, 2014 at 1:40 pm
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.
December 11, 2014 at 1:44 pm
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.
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]
December 12, 2014 at 1:45 pm
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