首页 / 词典 / good

reorg

  • 网络重组;重整;表重组;表执行重组;重组数据表空间
reorgreorg
  1. At last , a true low-overhead online table reorg capability .

    最后,一个真正的低开销在线表格重组功能。

  2. This provided some improvement on the table reorg problem , because you could use these options to perform a partial reorganization in the background without taking the table offline .

    这为表重组问题提供了一些改进,因为您可以使用这些选项来在后台执行一个部分重组,而不需要让表处于脱机状态。

  3. REORG also helps us implement another performance feature of DB2 .

    REORG还帮助我们实现DB2的另一个性能特性。

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

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

  5. The REORG utility can be used in many ways beyond purging data .

    除了清理数据,REORG实用程序可以通过多种方式使用。

  6. The REORG uses a sampling technique to build the dictionary .

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

  7. Also , there should not be any need to run the REORG utility .

    而且,也没有任何必要去运行REORG实用程序。

  8. They can increase logging during the REORG process .

    会在REORG过程中增加日志。

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

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

  10. The dictionary gets updated for every subsequent REORG operation .

    对于以后的每次REORG操作,更新表词典。

  11. At a later time , REORG can be used to put the rows back in cluster order .

    一段时间以后,REORG可用来将各行以集群顺序放回。

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

    当到处移动表数据时,RUNSTATS和REORG实用程序都使用日志文件。

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

    您在创建新索引之后运行reorg和runstats命令,如下所示

  14. Before you apply new stats to the database , I recommend you reorg the data first .

    在您将新语句应用到数据库之前,我建议您首先重新组织数据。

  15. Deploying table spaces on SSDs can reduce the need to REORG .

    在SSD上部署表空间可以减少REORG的需要。

  16. A third problem can occur when performing RUNSTATS or REORG on your table .

    当对表执行RUNSTATS或REORG时,可能出现第三个问题。

  17. And since they are written in physical clustering sequence , there should be no need to REORG .

    由于这些行是按照物理的群集顺序来写的,因此不需要运行REORG。

  18. Here are a few things to keep in mind when using partition-level REORG

    在使用分区级别REORG时,要注意以下几个问题

  19. He reminds his team to use the reorg utility , which clusters the data for efficient access .

    他提醒他的团队使用重新组织实用工具,该工具会收集数据以实现有效访问。

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

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

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

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

  22. When a table has been reorganized with the REORG utility .

    当用REORG实用程序重新组织表时。

  23. Remember , REORG is basically an unload and a reload of data .

    请记住,REORG从根本上说是卸载和重新加载数据。

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

    以下例子阐明了如何在不含全局索引的表上应用分区级别REORG

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

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

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

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

  27. In this policy , the REORG TABLESPACE and LOAD utilities are being monitored for specific syntax parameters .

    在这个策略中,REORGTABLESPACE和LOAD实用程序正在受到监视,监视它们是否使用特定的语法参数。

  28. However , you can only create a compression dictionary using either the offline reorg table command or the inspect utility .

    但是,只能使用离线reorgtable命令或inspect实用程序来创建压缩字典。

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

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

  30. You need to monitor the system ( ideally in an automated fashion ) to determine when a REORG needs to be run .

    您需要监控系统(最好通过自动方式)来决定何时运行REORG。