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.
如果不需要重构所有索引,您可以使用其他参数只对部分索引进行重构。
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.
那么得先找出这个表有哪些索引,哪些索引是位图索引,怎么查呢?
应用推荐