Update statistics is run only on logged databases.
统计数据更新只能在启用了日志的数据库上执行。
Using the "reorgchk update statistics" command.
使用“reorgchkupdate statistics”命令。
Perform DB2 reorgchk on all the tables to update statistics.
在所有表上执行DB 2reorgchk来更新统计数据。
The UPDATE STATISTICS command is not executed automatically.
UPDATE STATISTICS命令不会自动执行。
Version 4: to UPDATE STATISTICS for a stored procedure in a database.
版本4：用于数据库中某个存储过程的UPDATE STATISTICS。
What do you mean by executing UPDATE STATISTICS on a stored procedure?
在存储过程上执行update STATISTICS是什么意思？
Informix V11.7 introduces an AUTOMATIC mode of operation for update statistics.
Informix V11.7为update statistics引入了AUTOMATIC操作模式。
The auto Update Statistics feature is the subject of a later article in this series.
AutoUpdate Statistics特性是本系列后面一篇文章的主题。
The value 0 disables automatic update statistics operation (original server behavior).
如果为0 ，则禁用自动升级统计（原始服务器行为）。
UPDATE STATISTICS should be run after initially loading the data and creating indexes.
初次装载数据和创建索引之后，应该运行UPDATE STATISTICS。
To populate the distribution of data, run UPDATE STATISTICS in the medium or high mode.
为了填充数据分布，以medium或high模式运行UPDATE STATISTICS。
So, DBAs tend to reduce the frequency of running update statistics to avoid the overhead.
因此，DA通常会降低运行update statistics的频率来避免系统开销。
You can use this section to create new tables, set a filter to tables, or run update statistics.
您可以使用这个部分创建新表、设置表过滤器或运行更新统计数据。
AUTO means to use AUTOMATIC mode of update statistics thereby enforcing smarter statistics.
AUTO意味着使用AUTOMATIC模式的update statistics，从而执行智能统计。
Version 3: To UPDATE STATISTICS for a particular column of a particular table in a database.
版本3：用于数据库中特定表的特定列的UPDATE STATISTICS。
To sum it all up, use the UPDATE STATISTICS statement to perform any of the following tasks.
总之，应使用UPDATE STATISTICS来执行以下任何任务。
OpenAdmin Tool provides support for \ most of the IDS 11 features MACH 11, Auto update statistics.
OpenAdmin Tool为大部分IDS11特性MACH 11自动更新统计数据提供支持。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时，查询优化至关重要，而UPDATE STATISTICS正是用于此目的。
All tables involved in the query must have at least UPDATE STATISTICS LOW run against the table.
查询中涉及的所有表都至少必须有update STATISTICSLOW运行。
To enable the automatic mode of update statistics, set the ONCONFIG variable AUTO_STAT_MODE to 1.
要启用update statistics的自动模式，将onconfig变量auto_stat _ mode设为1。
These features impact and improve the way update statistics collects information for the optimizer.
这些特性将影响并改善update statistics为优化器收集信息的方式。
Two ways to update statistics — without dropping of objects dependent on the nickname — are outlined below.
下面给出了更新统计信息的两种方法——不删除依赖于昵称的对象。
Use UPDATE STATISTICS MEDIUM DISTRIBUTIONS ONLY if queries have non-indexed join columns or filter columns.
仅当查询中有非索引连接列或过滤列时，才使用UPDATE STATISTICSMEDIUMDISTRIBUTIONS。
This map is used subsequently when JDBC statements are executed to update statistics for the appropriate request.
随后在执行jdbc语句更新对应请求的统计值时，会使用这个图。
Use UPDATE STATISTICS HIGH if queries have a multi-column indexed defined on join columns or filter columns.
如果查询中有属于多列索引的连接列或过滤列，则使用UPDATE STATISTICSHIGH。
New features in IBM Informix V11.7 let you dramatically improve the performance of running update statistics.
IBMInformixV11.7中的新特性使您能够极大地改善运行update statistics的性能。
So it is obvious that the accuracy of selectivity estimation depends upon how often you run UPDATE STATISTICS.
因此，选择性估算的准确性显然基于您运行UPDATE STATISTICS的频率。
Therefore, UPDATE STATISTICS cannot be compared to executing the query itself unless it is run in the high mode.
因此，除非以high模式运行，否则UPDATE STATISTICS与执行查询本身是不能相提并论的。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
在我们对基准的第一个改进中，我们向账单表增加索引，并为表更新统计信息。
Tables and indexes with changes less than the imposed STATCHANGE are completely skipped during update statistics.
在update statistics期间，数据修改小于所设置的STATCHANGE的表和索引将被直接跳过。
应用推荐