然而，我们将会为其更新统计数据。
在所有表上执行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.
智能统计可以极大地缩短对大型系统更新统计数据所需的时间。
The effect of smarter statistics can be quite profound on the amount of time it takes to update statistics on large systems.
运行统计数据advisor 工具，并采取行动更新统计数据。
Run the statistics advisor and take actions to make statistics current.
另外，还建议您配置一个额外的新维护作业，只在每天夜间“更新统计数据”。
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.
有三种模式可用于更新统计数据：low、medium和high。
The three modes updating the statistical data are low, medium and high.
任何自动垃圾邮件或者非垃圾邮件报告解决方案还应该相应地更新统计数据。
Any auto spam or ham reporting solution should also update the stats, accordingly.
因此，用于更新统计数据的update语句可能失败并产生SQL 1227n错误消息。
Hence, the update statements to update the statistics can fail with the SQL1227N error message.
但是它不能灵活地运行多个并发脚本，来在同一数据库中根据不同的表来更新统计数据。
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.
OpenAdmin Tool为大部分IDS11特性MACH 11自动更新统计数据提供支持。
OpenAdmin Tool provides support for \ most of the IDS 11 features MACH 11, Auto update statistics.
许多Informix新客户没有认识到他们必须更新统计数据，因此由于缺少最新的优化器统计数据，他们的数据库性能很差。
Many customers new to Informix do not realize they must update statistics, and see poor performance due to the lack of optimizer statistics.
因此，当您最开始在系统上加载负载之后，或者无论何时数据库中的数据量剧烈变化，都应该通过运行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.
美国癌症状况年报由北美癌症登记协会、美国国家癌症研究所、美国疾病预防控制中心和美国癌症协会共同编写，用于提供截至2007年的癌症趋势更新统计数据。
The report, which was co-authored by the North American Association of Central Cancer Registries, NCI, CDC, and the American Cancer Society, provides updated statistics on cancer trends through 2007.
动态sql语句自动使用这些更新的统计数据。
Dynamic SQL statements automatically use these updated statistics.
由于没有自动运行UPDATESTATISTICS，所以systemcatalog表没有更新，仍然保留旧的统计数据。
Since the update STATISTICS are not run automatically, the System Catalog tables would not be updated and would still be retaining the old statistical data.
当测试正在运行时，SiteLoad显示并不断的更新象图7 中显示的统计数据。
While the test was running, SiteLoad displayed and constantly updated statistics like those shown in Figure 7.
List：提供用来运行统计数据更新的命令。
List: Provides the actual "Execution Command" to run update statistics.
用runstats命令更新目录统计数据，以便优化器可以考虑这个新创建的索引。
Update the catalog statistics with the runstats command so that the optimizer can take this newly created index into account.
StatisticalResourcesontheWeb：可以检索到各种最近更新的统计数据，从农业到商业、从劳动力到住房和军事。
Statistical Resources on the Web: Find updated statistics on everything from agriculture to business to labor to housing to the military.
还可以在Domino统计数据中检查复制条目(通过ShowStatReplica命令)，了解添加、删除和更新文档的速率。
You can also review the Domino statistics for replica entries (via the Show stat replica command) and see the rate of documents being added, deleted or updated.
对于索引统计数据的更新将失败，并发出 SQL1227Nrc=8错误消息（本例中），因为索引的FIRSTKEYCARD大于表的CARD。
The update for the index statistics would fail with a SQL1227N rc=8 error message (in this case) as the FIRSTKEYCARD of the index is greater than CARD of the table.
Alerts：提供缺少统计数据更新的表的详细信息。
Alerts: Provides details regarding tables missing "statistics update".
这篇文章主要是基于业界网站AngelList的数据(也可能不是，参见下文更新)，外加道琼斯公司(Dow Jones)的风投融资统计数据。
It's mostly based on AngelList data (or not, see update below), plus venture fund-raising statistics from Dow Jones.
此命令更新了系统目录中的统计数据，优化程序使用这些数据来确定成本最低的查询计划。
This command updates the statistics in the system catalogs that the optimizer USES to determine the lowest-cost query plan.
如果编目统计数据不准确，应该使用RUNSTATS更新它们。
If the catalog statistics are inaccurate, get them up to date with RUNSTATS.
PMI实现了这些统计接口，更新各种统计数据并通过不同的接口公开这些数据。
PMI implements these statistical interfaces, updates various statistical data, and exposes the data through various interfaces.
提示：定期更新数据库统计数据。
应用推荐