To enable each statistic, click JMS Queue Name and select the corresponding statistic from the checkbox to the right-hand side of the displayed statistics table.
要启用每种统计信息，单击JMSQueueName并从显示的统计表右侧的复选框中选择相应的统计信息。
This paper introduced a practical Statistics Table Checking system (STCS), which is developed by use of the principles of artificial intelligence and expert system.
本文介绍了一个实用的统计报表校核系统(STCS)，它的开发采用人工智能和专家系统的技术。
You can obtain the statistics from the table descriptor of the table node in the underlying access path graph.
您可以从基础访问路径图中的表节点的表描述符处获得该统计信息。
First analyze the access plan that the optimizer chooses when no distribution statistics are available, which is only basic statistics for the table CARS, and that its indexes exist.
首先来分析一下，在没有分布统计信息，而只有cars表的基本统计信息及其索引的情况下，优化器选择的访问计划是怎样的。
For example, refreshing of statistics can happen at fragment level, and fragment statistics can be added to, or removed from, table statistics.
例如，可以在片段级别上刷新统计数据，可以向表统计添加或从中移除片段统计。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
在我们对基准的第一个改进中，我们向账单表增加索引，并为表更新统计信息。
Also, an existing table has no statistics.
而且，现有表没有统计信息。
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.
相反，优化器将对查询中引用的每个数据库表收集最新的统计数据。
This means that you should either load your data prior to creating your index or update the statistics on your table after your data is loaded.
这意味着您应该在创建索引之前加载数据，或者在加载数据之后更新表的统计信息。
For ATTACH operation: fragmented statistics of the new fragment is built, and table level statistics is rebuilt from all fragmented statistics.
对于ATTACH操作：将对新的片段构建片段统计，并利用所有的片段统计重新构建表级统计。
For DETACH operation: table level statistics of the resulting tables are rebuilt from the fragmented statistics.
对于DETACH操作：生成的表的表级统计是使用片段统计重新构建的。
Perform this sequence of actions to enable both statistics summarized in Table 1.
执行操作序列以启用表1中总结的统计信息。
When enabled, automatic statistics collection helps improve database performance by ensuring that you have up-to-date table statistics.
启动时，动态统计数据集合可通过确保您拥有最新表统计信息来帮助提高数据库性能。
Inconsistent statistics may be caused when users collect the partial statistics, for example collecting table and index statistics individually, at different points in time.
用户只收集一部分数据可能会造成不一致的统计数据，例如，在不同时间分别收集表和索引统计数据。
Since the fragmented statistics are more granular than table statistics, they do take up more space as well.
因为片段统计比表统计更加细粒度，因此会占用更多的空间。
DB2 and IDS USES the statistics information in the catalog table to derive the best access plan.
DB2和IDS使用目录表中的统计信息来制定最佳访问计划。
In this example, 10 percent of table data pages are used for the collection of table statistics, while for index statistics all of the index pages will be used.
本例中，10%的表数据页用于表统计信息的收集，而对于索引统计信息，将使用所有的索引页。
So for the table statistics, the CARD will show as 1,100,000.
因此对于表统计数据，CARD将显示为1,100,000。
Statistics for each column in the table.
表中各列的相关统计信息。
You cannot run UPDATE STATISTICS against an external table.
不能针对一个外部表运行updateSTATISTICS。
Version 2: To UPDATE STATISTICS for a particular table in a database.
版本2：用于数据库中特定表的UPDATESTATISTICS。
Screen cap: Table showing statistics of executed statements.
屏幕图：执行的语句的统计数据。
This command will ignore the STATCHANGE computation and rebuild all the table tab1 statistics.
该命令将忽略STATCHANGE计算并重建所有表tab1统计。
The first runstats commands collects the most comprehensive and detailed statistics for the table customer and all its indexes without sampling.
第一个runstats命令为表customer和它的所有索引收集最全面、最详细的统计信息，而没有采用抽样。
The following RUNSTATS command collects only the basic statistics for the table CARS (in schema SAMPLE) and the corresponding indexes.
下面的RUNSTATS命令只收集cars表(在模式sample中)和相应索引的基本统计信息。
Example 5: Collect catalog statistics on the table and indexes without distribution statistics.
示例5：收集表和索引上的目录统计信息，不包含分布统计信息。
Example 9: Collect catalog statistics on the table and indexes with distribution statistics
示例9：收集表和索引上的目录统计信息，包含分布统计信息
SYSSTAT views containing the table, column, and index statistics.
SYSSTAT视图，包含表、列和索引统计数据。
Example 10: Collect catalog statistics on the table and enhanced statistics on the indexes, as well as distribution statistics.
示例10：收集表上的目录统计信息以及索引上的详细统计信息，包含分布统计信息。
Example 12: Collect catalog statistics on only the table, with basic column statistics for deptno and deptname and distribution statistics on mgrno and admrdept.
示例12：只收集表上的目录统计信息，包含deptno和deptname上的基本列统计信息以及mgrno和admrdept上的分布统计信息。
应用推荐