世卫组织如何收集统计信息？
收集统计信息，包含10%行上的分布统计信息。
Example 29. Collect statistics, including distribution statistics on 10 percent of the rows.
接着，它展示了总体的垃圾收集统计信息。
发布到JMS主题的信息用于收集统计信息。
Information published to the JMS topic is used for collecting statistics.
对大的系统收集统计数据会占用较长的时间。
Collecting statistics on large systems can take a long time.
当您运行这个脚本时，工具立即开始收集统计数据。
When you run this script, the tool immediately starts collecting statistics.
中国代表强调，登记制的目的仅为收集统计信息。
The representative of China emphasized that the purpose of the registration system was only to gather statistical information.
另外还需要收集统计信息，重新构建所有无效的索引。
The statistics need to be collected and all invalid indexes rebuilt.
这将避免为了收集统计信息而进行的另一项索引扫描。
This avoids another scan of the index in order to gather statistics. The following examples illustrate some of the options available to do this.
接下来，收集统计信息，这样系统表中会出现一些数据。
Next, collect statistics so that the system tables will be populated.
SAMPLE在创建最初，还没有在表上收集统计信息。
When the SAMPLE database is initially created, statistics are not collected on the tables.
下列例子说明如何使用RUNSTATS收集统计信息？
The following examples illustrate using RUNSTATS to collect statistics.
自动统计信息配置则通过确定何时和如何收集统计信息更进了一步。
Automatic statistics profiling goes one step further by determining when and how to collect statistics.
在employee表和它的新的及剩余的索引上再次收集统计信息。
Statistics are re-collected on the EMPLOYEE table and its new and remaining indexes.
在某些情况下，收集统计信息需要的时间可能比执行查询的时间更长。
In some cases, gathering the statistics might take longer than executing the query.
此外，还需要手动收集统计信息，因为runstats不能工作于统计视图。
In addition, manual collection of statistics is needed, since runstats do not work on the statistical view.
这说明该算法只使用集群的dc列，对于其他的列来说，则只收集统计信息。
This instructs the algorithm to only use the DC columns for clustering, for the other columns, only statistics are collected.
不过，最好是在创建索引之后再执行LOAD命令，并在LOAD期间收集统计信息。
However, it is preferable to create indexes before performing the LOAD command, and collecting statistics during the LOAD.
为了控制收集统计信息的样本集，以及可以重复使用相同的样本集，需要使用下列语句。
Example 30. To control the sample set on which the statistics will be collected and to be able to repeatedly use the same sample set, use the following.
这种收集统计信息的方法对于远程视图上的昵称特别有用，因为数据源通常不收集关于视图的统计信息。
This method of collecting statistics is particularly helpful for nicknames over remote views, because the data sources typically do not collect statistics on views.
为了可以对一个表或索引收集统计信息，必须能够连接到包含该表和索引的数据库，并具有下列授权级别之一
To be able to collect statistics against a table or index, one must be able to connect to the database that contains the tables and indexes and have one of the following authorization levels
对于数据库中的所有表，收集统计信息的一个可供选择的方法就是发出一条REORGCHK命令，如下所示。
One alternative way of collecting statistics for all tables in a database is to issue a REORGCHK command as follows.
例如，对于实现按需运行的报告(它从关系数据库收集统计信息，并向用户显示这些信息)来说，这就是一种好方法。
For instance, this would be a good approach to implementing a run on demand report that compiles statistics from the relational data and displays them to the user.
随着数据库快速不断地增长，通过访问所有数据收集统计信息的能力可能会受到固定的批量窗口、内存和CPU约束的阻碍。
With databases growing at an unrelenting pace, the ability to collect statistics by accessing all of the data may be hampered by fixed batch Windows or memory and CPU constraints.
这对收集统计信息而言至关重要，然后可以将这些统计信息拖入另一个程序，以对其进行深入分析、生成有关它的报告，等等。
This is great for collecting statistics that you can then drop into another program to do deep analysis on, generate reports on, and so on.
其次，NNSTAT存储过程现在允许选择统计信息收集方法，并提供了对要为之收集统计信息的列和索引的细粒度的控制。
Secondly, the NNSTAT stored procedure now offers a choice of statistics-gathering methods, as well as fine-grained control over the columns and indexes for which statistics are to be collected.
在没有列组统计信息的情况下再次收集统计信息的话，优化器会选择一个类似如下所示的查询访问计划，它的基数估计值为2。
A query access plan similar to the following is chosen by the optimizer, with a cardinality estimate of 2.
在没有列组统计信息的情况下再次收集统计信息的话，优化器会选择一个类似如下所示的查询访问计划，它的基数估计值小于2。
A query access plan similar to the following is chosen by the optimizer, with a cardinality estimate under 2.
还可以设置单个dpar，从多个DPAR中收集统计信息，这样就可以拥有单个合并的Statrep . nsf数据库，而不是多个。
You can also set up a single DPAR to collect the statistical information from multiple DPARs, so you can have a single consolidated Statrep.nsf database instead of many.
stat_heap_sz或统计信息堆大小的数据库配置参数指定了使用RUNSTATS命令收集统计信息中所用堆的最大尺寸。
The stat_heap_sz or the statistics heap size database configuration parameter indicates the maximum size of the heap used in collecting statistics using the RUNSTATS command.
应用推荐