然而，我们将会为其更新统计数据。
智能统计可以极大地缩短对大型系统更新统计数据所需的时间。
The effect of smarter statistics can be quite profound on the amount of time it takes to update statistics on large systems.
运行updatestatistics命令，创建或者更新统计。
Run the update statistics command to create or refresh statistics.
在所有表上执行DB 2reorgchk来更新统计数据。
Perform DB2 reorgchk on all the tables to update statistics.
本例中，我们将看到没有正确更新统计数据时计划是如何变化的。
In this example, we'll see how the plan changes when the statistics are not updated properly.
您可以使用这个部分创建新表、设置表过滤器或运行更新统计数据。
You can use this section to create new tables, set a filter to tables, or run update statistics.
下面给出了更新统计信息的两种方法——不删除依赖于昵称的对象。
Two ways to update statistics — without dropping of objects dependent on the nickname — are outlined below.
任何自动垃圾邮件或者非垃圾邮件报告解决方案还应该相应地更新统计数据。
Any auto spam or ham reporting solution should also update the stats, accordingly.
运行统计数据advisor 工具，并采取行动更新统计数据。
Run the statistics advisor and take actions to make statistics current.
有三种模式可用于更新统计数据：low、medium和high。
The three modes updating the statistical data are low, medium and high.
重建将自动重建所有索引列统计信息，而重新组织根本不会更新统计信息。
REBUILD will automatically rebuild all index-column statistics, whereas REORGANIZE won't update statistics at all.
在我们对基准的第一个改进中，我们向账单表增加索引，并为表更新统计信息。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
另外，还建议您配置一个额外的新维护作业，只在每天夜间“更新统计数据”。
In addition, it is also recommended that you configure an additional new maintenance job, which merely "update the statistics" every night.
更新统计数据是最重要的管理任务之一，它确保优化器选用最佳的查询执行计划。
Updating statistics is one of the most important administrative tasks that ensure the optimizer picks optimum execution plans for your queries.
但是它不能灵活地运行多个并发脚本，来在同一数据库中根据不同的表来更新统计数据。
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.
比起在整个示例应用程序中用分散的调用更新统计值和跟踪上下文，这是一个重大的改进。
This is a major improvement over scattering calls to update statistics and to track context throughout my example application.
因此，用于更新统计数据的update语句可能失败并产生SQL 1227n错误消息。
Hence, the update statements to update the statistics can fail with the SQL1227N error message.
触发器可以设置为实时更新统计结果。系统通过调用带有统计触发器的子程序来执行实时更新动作。
Real-time update is done by calling a subprogram with the statistical trigger code as an argument.
OpenAdmin Tool为大部分IDS11特性MACH 11自动更新统计数据提供支持。
OpenAdmin Tool provides support for \ most of the IDS 11 features MACH 11, Auto update statistics.
这些可更新的视图允许更新某些统计信息，从而研究假想数据库的性能，或者更新统计信息而不使用RUNSTATS实用程序。
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.
其目标是允许DB2确定工作负载需要哪些统计信息，并定期在后台自动运行RUNSTATS实用程序，以便按需更新统计信息。
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.
因此，当您最开始在系统上加载负载之后，或者无论何时数据库中的数据量剧烈变化，都应该通过运行DB2RUNSTATS实用程序更新统计数据。
Therefore, after initially putting load on your system, or whenever the data volume in the database changes significantly, you should update the statistics by running the DB2 RUNSTATS utility.
然后可以编写建议，更新性能统计，而在进入或退出任何一个连接点时，都会自动调用建议。
You can then write advice that updates performance statistics, which can be invoked automatically whenever you enter or exit one of the join points.
如果为一个昵称收集了统计信息，那么在数据源上对相应远程表的远程统计信息进行更新时，这些统计信息不会自动更新。
Once the statistics are gathered for a nickname, they are not automatically modified when the remote statistics are updated on the data source for the corresponding remote table.
更新目录统计信息，这部分强调收集和维护最新数据库统计信息的重要性，缺少这项工作常常是导致许多性能问题的源头所在。
Updating catalog statistics, which emphasizes the importance of collecting and maintaining up-to-date database statistics, the lack of which is often the source of many of the performance problems.
DB 2优化器使用目录统计信息来确定最佳的访问路径，而更新这些目录统计信息所采用的主要方法就是运行RUNSTATS实用程序。
The DB2 optimizer USES catalog statistics to determine the best access path, and the main method employed to update these catalog statistics is to run the RUNSTATS utility.
PMI实现了这些统计接口，更新各种统计数据并通过不同的接口公开这些数据。
PMI implements these statistical interfaces, updates various statistical data, and exposes the data through various interfaces.
昵称统计信息更新功能，它允许更新昵称统计信息。
The nickname statistics update facility, which allows you to update nickname statistics.
统计信息已被更新，不但填充了nrows，而且我们还看到统计信息最终被更新了。
Statistics have been updated, and not only is nrows populated but we also see when statistics were last updated.
统计信息已被更新，不但填充了nrows，而且我们还看到统计信息最终被更新了。
Statistics have been updated, and not only is nrows populated but we also see when statistics were last updated.
应用推荐