If you expect an index to have a high cluster factor, just reorganize the table on that index.
如果您期望一个索引具有较高的群集因子,就只要重组该索引上的表。
The main purpose of allocating free space is to keep the data rows in the same physical sequence as the clustering index, thus reducing the need to frequently reorganize the data.
分配空余空间的主要目的是使数据行的物理顺序与群集索引一致,以减少频繁重组数据的需要。
The way to establish a certain data clustering property in DB2 is to reorganize the table according to an index.
在DB 2中建立数据聚集属性的方法是根据一个索引对表进行重组。
An index reorganize will only take care of the existing fragmentation.
现有的碎片将只负责索引重新组织。
REBUILD will automatically rebuild all index-column statistics, whereas REORGANIZE won't update statistics at all.
重建将自动重建所有索引列统计信息,而重新组织根本不会更新统计信息。
REBUILD will automatically rebuild all index-column statistics, whereas REORGANIZE won't update statistics at all.
重建将自动重建所有索引列统计信息,而重新组织根本不会更新统计信息。
应用推荐