HEAP表巨大的碎片减少问题 [英] HEAP table huge fragmentation reduction issue

问题描述

大家好：

 我有几个堆表，碎片级别约为99％。我知道最好的解决方案是创建一个集群索引并保持在那里，但我必须暂时使用临时修复。 

临时修复是alter table xxxxx rebuild或创建一个集群索引并立即删除它。 

但是，我尝试了几次改变表重建，avg_fragmentation_in_percent最初下降但是几轮后， 

它实际上回升了吗？

我还试图创建一个集群索引并检查碎片，它是完全消失了。但是，在我删除集群索引并检查sys.dm-db-index_physical_stats（）之后，碎片级别又回到了旧的状态。

我做错了什么？ 

欢呼

  HS

---

- 目前正在使用Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008，SVN -

解决方案

如果您在堆上运行   Alter table TableName重建怎么办？

还阅读我的旧博客

http://dimantdatabasesolutions.blogspot.com/2009/10/has-fragmentation-impact-on-performance html的

hi folks:

 I have several heap tables with around 99% fragmentation level. I understand that best solution is to create a cluster index and stay there but I have to go for the temp fix for the time being. 

Temp fix are either alter table xxxxx rebuild or create a cluster index and immediately drop it. 

However, I tried alter table rebuild a few times , the avg_fragmentation_in_percent initially dropped but after a few rounds, 

it actually rose back? 

Also I tried to create a cluster index and check the fragmentation , it is gone totally. However after I dropped the cluster index and check sys.dm-db-index_physical_stats(), the fragmentation level is back to the same old. 

Did I do something wrong ? 

cheers

 HS

---

--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

解决方案

What if you run  Alter table TableName rebuild on your heap?

Also read my old blog

http://dimantdatabasesolutions.blogspot.com/2009/10/has-fragmentation-impact-on-performance.html

这篇关于HEAP表巨大的碎片减少问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！