• When a table has been reorganized with the reorg utility.

    REORG实用程序重新组织时。

    youdao

  • The REORG USES a sampling technique to build the dictionary.

    REORG使用一种抽样技术建立字典

    youdao

  • The dictionary gets updated for every subsequent REORG operation.

    随后每次REORG操作中,表字典随之更新。

    youdao

  • Behavior changes in row compression using the offline reorg utility.

    使用离线reorg实用程序压缩中的行为变化

    youdao

  • Rename, alter, reorg, refresh, nickname, comments, or lock statements.

    refreshnicknamecommentslock语句

    youdao

  • Here are a few things to keep in mind when using partition-level reorg.

    使用分区级别REORG注意以下几个问题。

    youdao

  • You should run reorg and runstats after creating new indexes, as shown below.

    创建索引之后运行reorgrunstats命令如下所示。

    youdao

  • The REORG TABLE step between two scenarios will establish the clustering order.

    两个场景之间REORGTABLE步骤建立聚集顺序

    youdao

  • Both the RUNSTATS and REORG utilities use log files when moving table data around.

    到处移动数据时,RUNSTATSREORG实用程序使用日志文件

    youdao

  • Taken together, they represented the biggest reorg of the Pentagon in a generation.

    两者合计他们代表一代人五角大楼最大重组。

    youdao

  • The following examples illustrate partition-level REORG on a table that has no global indexes.

    以下例子阐明了如何在全局索引应用分区级别reorg

    youdao

  • Reorg index - For example, reorg indexes all for table <Schema Name>.

    allow no access

    Reorgindex ——比如reorgindexesallfortable <SchemaName>.

    allownoaccess

    youdao

  • Extra indexes also add to the CPU consumption of certain DB2 utilities, such as the REORG utility.

    额外索引会增加某些DB2实用工具(比如 REORG 实用工具)CPU 占用。

    youdao

  • This is also why maintenance operations like REORG cannot be performed on an individual local index.

    也是无法单个本地索引执行类似 REORG维护操作原因

    youdao

  • REORG will restore a disorganized index to a well-organized state, at a cost of some CPU consumption.

    REORG一个组织混乱索引恢复良好组织状态,但要以一些CPU消耗代价

    youdao

  • Based on the data and trends you observe, adjust your REORG frequency and PCTFREE number accordingly.

    根据当前的数据以及所观察到趋势,对REORG频率PCTFREE数字进行相应调整

    youdao

  • In DB2 9, the default compression dictionary directive for the REORG TABLE command is KEEPDICTIONARY.

    DB 29中,REORGTABLE命令中的默认压缩字典指令是KEEPDICTIONARY

    youdao

  • DB2 provides various utilities, such as RUNSTATS, REORG and REORGCHK, to improve database performance.

    DB 2提供了各种实用程序提高数据库性能RUNSTATSREORGREORGCHK

    youdao

  • Just like the offline table reorg, LOAD REPLACE has both the KEEPDICTIONARY and RESETDICTIONARY options.

    离线table reorg一样LOADreplacekeepdictionaryRESETDICTIONARY选项

    youdao

  • Conversations with folks at IBM reveal a viewpoint within the company that DBAs may reduce REORG frequency.

    IBM员工的谈话揭示公司内部一个观点DBA可能会降低reorg频率

    youdao

  • For more information, see the "2.4 Behavior changes in row compression using offline reorg utility" section.

    了解更多信息请参阅“2.4使用离线reorg实用程序压缩中的行为变化小节

    youdao

  • The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.

    只有执行 REORG时候构建字典之后便可以压缩中的数据

    youdao

  • In most cases, ALTER SET DATA TYPE requires table reorganization (reorg) because it changes the physical row format.

    大多数情况下ALTERSETDATATYPE需要对执行重组(reorg),因为修改物理格式

    youdao

  • Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.

    这些操作redistributetable reorgindexcreaterunstats每个操作都需要扫描一次数据

    youdao

  • Thus the UPDATE statement fails to find the row with the row CHANGE TOKEN that was retrieved before the REORG occurred.

    因此update语句无法找到具有ROWCHANGETOKEN这些发生REORG之前检索得到的。

    youdao

  • Additionally, DSNACCOX with DB2 10 has specific code to reduce the REORG requirements for table Spaces residing on SSDs.

    另外DB 210DSNACCOX具有特定的代码降低驻留SSD上的磁盘空间REORG需求

    youdao

  • If you use the offline table reorg or rowcompestimate option in the inspect tool, data in the table is fully compressed.

    如果inspect工具使用离线table reorgrowcompestimate选项,则中的数据完全压缩

    youdao

  • In order to synchronize with the new ADC feature, the behavior of KEEPDICTIONARY for the offline table reorg has changed.

    为了新的adc特性同步离线table reorgKEEPDICTIONARY行为已经被更改

    youdao

  • Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.

    因此REORG常常可以产生能代表整个空间分区中的数据字典

    youdao

  • The following REORGCHK command examines whether the REORG is required and also updates the statistics on table bench.customer.

    下列REORGCHK命令检查是否需要REORG,并且更新关于bench .customer的统计信息

    youdao

  • $firstVoiceSent
    - 来自原声例句
    小调查
    请问您想要如何调整此模块?

    感谢您的反馈,我们会尽快进行适当修改!
    进来说说原因吧 确定
    小调查
    请问您想要如何调整此模块?

    感谢您的反馈,我们会尽快进行适当修改!
    进来说说原因吧 确定