What are the primary differences between an index reorganization and an index rebuild?
索引重组和索引重建主要区别有哪些？
An index rebuild will always rebuild the entire index, regardless of the extent of fragmentation.
索引重建始终将重建整个索引，而无需考虑的碎片的程度。
Since each index (fragment) has its own UDI counter, the decision to skip or rebuild index statistics is done based on how much the index (fragment) has changed.
由于每个索引(片段)都有自己的udi计数器，因此将根据索引(片段)的修改程度判断是否跳过或是重建索引统计。
This means that DB2 chooses either the rebuild or incremental index maintain approach, whichever is the best fit.
这意味着，DB 2从重新构建和增量索引维护两种方法中选择最合适的方法。
Perform index reorganizations online and rebuild compression dictionaries when table reorganization takes place.
在线执行索引重组，并在发生表重组时重构压缩字典。
Manual index regeneration is often required when a large amount of content has been loaded into Workplace Web content Management through syndication during a rebuild.
在重建过程中，当通过联合将大量的内容载入WorkplaceWebContentManagement时，经常需要手工重新生成索引。
You can use a different argument to rebuild fewer if you don't need to rebuild every index.
如果不需要重构所有索引，您可以使用其他参数只对部分索引进行重构。
In this situation, you should rebuild the search index catalog.
在这种情况下，您应该重建搜索索引编录。
REBUILD requires building the new index before dropping the old one.
重建需要除去旧之前建立新的索引。
Need EXCLUSIVE writeable access to rebuild structural index.
需要独占可写权进行结构索引的重建工作。
Either that, or rebuild the index.
要么，或重新生成索引。
In that case it would be better to just rebuild the index.
在这种情况会更好一些，只需重建索引。
REBUILD will automatically rebuild all index-column statistics, whereas REORGANIZE won't update statistics at all.
重建将自动重建所有索引列统计信息，而重新组织根本不会更新统计信息。
The LOB index is an internal structure that is strongly associated with LOB storage. This implies that a user may not drop the LOB index and rebuild it.
lob索引是内部结构，同lob存储紧密联系，这意味看用户无法删除并且重建lob索引。
You can create an index as compressed, or rebuild it to compress it although there are some restrictions about online rebuilds, rebuilds of partitioned indexes etc.
你可以创建一个压缩索引，或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.
那么得先找出这个表有哪些索引，哪些索引是位图索引，怎么查呢？
Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.
那么得先找出这个表有哪些索引，哪些索引是位图索引，怎么查呢？
应用推荐