在这种情况下，它可以更好地重新组织索引，以最小化事务日志。
In such cases, it can be better to reorganize indexes to minimize the transaction log.
在这种情况下，重新组织索引可能会影响DB2的选择，可能产生性能更好的查询访问路径。
In that case, reorganizing the index might lead to its selection as part of a better-performing query access path.
重新组织索引时，除了重新组织一个或多个索引外，默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
现有的碎片将只负责索引重新组织。
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.
应用推荐