Wednesday, January 1, 2014
How to fix the fragmentation on heaps?
We know that heaps are the tables without clustered index on. It may have many non clustered index (NCI) but still it is considered a heap. So consider a huge table (heap) that is fragmented. How would you fix it? Technically, you cannot defrag a heap table. But remember we have ALTER table REBUILD command which works very well on the heaps. But there is one big But. If you have many NCI on the table this command will rebuild all of them at once. What does it mean? It can produce transaction-log bloat which hits the over all performance. Think about the process the scan the log or perhaps Log Shipping job that needs to move the log file to the remote server. All this affects performance.
So, to answer the question ,we need to create a clustered index on that table..That is simple answer to the question.
Happy New Year to all!
Subscribe to:
Post Comments (Atom)
10 comments:
Thanks for giving me the useful information. I think I need it!
Happy Wheels , FNAF World , Five Nights At Freddy's
Would be awesome to know where I are able obtain it. Please maintain up the very good job. We all require far more such website owners like you on the net and much fewer spammers. Fantastic mate! Jean Claude Van Damme | Jean Claude Van Damme | Jean Claude Van Damme | Racing Games
After all, life is also because you are self-employed, success or failure, forward or also stalled by you only.
download musicas , snapchat baixar , run 3 , b612 , geometry dash apk
create the clustered index,, then drop it, maybe ? heap is happy ? Thank you.
Great! I like your post so much dragracerv3game.com
This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something like this
lennyfacetext.com
I was very impressed by this post, this site has always been pleasant news. Thank you very much for such an interesting post. Keep working, great job! In my free time, I like play game: vex3game.com. What about you?
I would like to thank you for the efforts you have made in writing this article.
sushi-cat2.com
It seems I'm on the right track, I hope I can do well. The result was something I did and was doing to implement it.
www.clickjogosclick.com
I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
Very interesting blog.
www.baixarfacebookgratis.com.br
Post a Comment