• Using the "reorgchk update statistics" command.

    使用“reorgchkupdate statistics”命令。

    youdao

  • Informix V11.7 introduces an AUTOMATIC mode of operation for update statistics.

    Informix V11.7为update statistics引入了AUTOMATIC操作模式。

    youdao

  • You can use this section to create new tables, set a filter to tables, or run update statistics.

    您可以使用这个部分创建新表、设置表过滤器或运行更新统计数据。

    youdao

  • These features impact and improve the way update statistics collects information for the optimizer.

    这些特性将影响并改善update statistics为优化器收集信息的方式。

    youdao

  • New features in IBM Informix V11.7 let you dramatically improve the performance of running update statistics.

    IBMInformixV11.7中的新特性使您能够极大地改善运行update statistics的性能。

    youdao

  • When STATCHANGE is set in a session, it affects the tables on which update statistics is run in that session.

    当在会话中设置STATCHANGE后,它将影响该会话中在其上运行update statistics的表。

    youdao

  • Tables and indexes with changes less than the imposed STATCHANGE are completely skipped during update statistics.

    在update statistics期间,数据修改小于所设置的STATCHANGE的表和索引将被直接跳过。

    youdao

  • In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.

    在我们对基准的第一个改进中,我们向账单表增加索引,并为表更新统计信息。

    youdao

  • Note: The AUTO and FORCE keywords work with ALL modes of update statistics and have no effect on procedure statistics.

    注意:AUTO和FORCE关键字需在update statistics的ALL模式下使用,并且不会对程序统计产生影响。

    youdao

  • These values are then used by consecutive update statistics runs to determine if existing statistics are good or stale.

    连续运行的update statistics将使用这些值来判断现有的统计数据是否过时。

    youdao

  • The effect of smarter statistics can be quite profound on the amount of time it takes to update statistics on large systems.

    智能统计可以极大地缩短对大型系统更新统计数据所需的时间。

    youdao

  • The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.

    可以使用runstats实用程序来更新系统编目表中的统计信息,使查询优化过程更容易一些。

    youdao

  • This is a major improvement over scattering calls to update statistics and to track context throughout my example application.

    比起在整个示例应用程序中用分散的调用更新统计值和跟踪上下文,这是一个重大的改进。

    youdao

  • You can use the AUTO and FORCE keywords in the update statistics command to specify if Smarter statistics should be used or not.

    可以在update statistics命令中使用AUTO和FORCE关键字,指定是否需要使用智能统计。

    youdao

  • To update statistics on all the tables or a group of tables in DB2, you can use the REORGCHK command with the update statistics option.

    要对DB 2中所有表或一组表的统计信息进行更新,可使用REORGCHK命令以及UPDATE STATISTICS选项。

    youdao

  • Have you ever wondered if the update statistics command you are about to run is actually needed since the last time you updated statistics?

    自从最近一次更新过统计数据后,您是否想过您将要运行的update statistics命令是否真正必要?

    youdao

  • Many customers new to Informix do not realize they must update statistics, and see poor performance due to the lack of optimizer statistics.

    许多Informix新客户没有认识到他们必须更新统计数据,因此由于缺少最新的优化器统计数据,他们的数据库性能很差。

    youdao

  • The Auto Update Statistics (AUS) component of OAT is used to simplify the work of the DBA by running the update statistics command based on specific policies.

    OAT 的AutoUpdate Statistics (AUS)组件根据特定的策略运行统计数据更新命令,从而简化DBA的工作。

    youdao

  • However, it does not easily offer the flexibility of running multiple concurrent scripts to update statistics against different sets of tables in the same database.

    但是它不能灵活地运行多个并发脚本,来在同一数据库中根据不同的表来更新统计数据。

    youdao

  • The output file generated by the Design Advisor contains a set of DDL statements that create MQTs, refresh and update statistics on the MQTs, and create indexes on them.

    Design Advisor生成的输出文件包含一组ddl语句,用于创建MQT、刷新和更新MQT上的统计信息,以及在其上创建索引。

    youdao

  • With the smarter statistics feature, you can now configure the server to automatically detect and refresh only stale statistics when you run the update statistics command.

    通过使用智能统计特性,您可以对服务器进行配置,从而在运行update statistics命令时自动检测并刷新已过时的统计数据。

    youdao

  • For example, it automatically executes the RUNSTATS utility on a periodic basis to update statistics about the physical characteristics of a table and the associated indexes.

    例如,它周期性地自动执行RUNSTATS实用程序,以更新关于表及相关索引的物理特征的统计信息。

    youdao

  • Even if you configure and enable Smarter statistics, the AUTO and FORCE enhancements to update statistics command allows you to specify if only stale or all statistics should be refreshed.

    即使您配置并启用了智能统计,update statistics命令的AUTO和FORCE增强允许您指定是否对过时的统计或全部统计进行刷新。

    youdao

  • These updatable views allow you to update certain statistical information to investigate the performance of a hypothetical database, or to update statistics without using the RUNSTATS utility.

    这些可更新的视图允许更新某些统计信息,从而研究假想数据库的性能,或者更新统计信息而不使用RUNSTATS实用程序。

    youdao

  • The objective is to allow DB2 to determine which statistics are required by the workload, and automatically run the RUNSTATS utility in the background periodically to update statistics as needed.

    其目标是允许DB2确定工作负载需要哪些统计信息,并定期在后台自动运行RUNSTATS实用程序,以便按需更新统计信息。

    youdao

  • When you do not exactly know all the table names, or there are too many, the easiest way to do RUNSTATS is to use the "db2 reorgchk update statistics" command. The exact script looks like this

    当您不完全知道所有表名或表名实在太多时,进行RUNSTATS的最简单方法就是使用“db2reorgchkupdate statistics”命令。

    youdao

  • Update statistics is run only on logged databases.

    统计数据更新只能在启用了日志的数据库上执行。

    youdao

  • The UPDATE STATISTICS command is not executed automatically.

    UPDATE STATISTICS命令不会自动执行。

    youdao

  • Version 4: to UPDATE STATISTICS for a stored procedure in a database.

    版本4:用于数据库中某个存储过程的UPDATE STATISTICS。

    youdao

  • What do you mean by executing UPDATE STATISTICS on a stored procedure?

    在存储过程上执行update STATISTICS是什么意思?

    youdao

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

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

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