REORG TABLE的意思|示意
REORG表
REORG TABLE的网络常见释义
行重组 3、 对需要重组的表进行重组(REORG TABLE) DB2 V9 可以对表和索引进行自动重组。 要进行高效率的数据访问和获得最佳工作负载性能, 具有组织良好的表数据是很关键的。
REORG TABLE相关短语
1、 reorg table tablename index indexname 根据索引
REORG TABLE相关例句
The following examples illustrate partition-level REORG on a table that has no global indexes.
以下例子阐明了如何在不含全局索引的表上应用分区级别reorg ?
If a table is dropped, its segments become immediately available for reuse at the COMMIT point, without requiring the REORG utility to be executed.
如果一个表被删除,在执行COMMIT之际,它的段就立即可以为其他表所用,而不需要执行REORG实用程序。
All kinds of DB2 catalog statistics describe the table space condition, and IBM suggests thresholds as to when the REORG should occur. There are many downsides to reorgs.
各种DB 2目录统计信息都描述了表空间状况,IBM建议以REORG会出现的情况作为阈值。
Reorg in Progress 0x400 This is a transient state that is only in effect during a reorg operation. Issue a reorg TABLE command.
reorg in Progress 0x400这是一种只在进行重组(reorg)操作期间才有效的临时状态。
Compact on is the default for the redistribute utility, where it performs space compaction much like an offline table reorg does.
COMPACT ON是重分发实用程序的默认选项,它像离线table reorg那样执行空间压缩。
The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.
只有在执行 REORG 的时候才构建表字典,之后便可以压缩表中的数据。