为了允许自动生成统计信息配置文件，需要设置两个数据库配置参数。
To enable automatic statistics profile generation, set two database configuration parameters on.
DB2在生成统计信息时，不但能提供基本统计信息，还允许创建所谓的分布统计信息。
When generating statistics, DB2 offers the possibility to create so-called distribution statistics in addition to the basic statistics.
如前所述，在使用RUNSTATS命令生成统计信息时，并不是总会收集分布统计信息。
As already mentioned, distribution statistics are not always collected when statistics are generated using the RUNSTATS command.
HAT工具会对在单个转储中具有大量实例的数据类型生成统计信息，并且还可以比较两个堆转储，以标识在数量上增加的数据类型。
The HAT tool produces statistics for data types that have large number of instances in a single dump and can also compare two heap dumps to identify data types which have increased in number.
还需要以合适的方式进行存储，以便您可以对输出结果生成有价值的统计信息。
It also needs to be stored in such a way that you can produce useful statistics on the output.
这对收集统计信息而言至关重要，然后可以将这些统计信息拖入另一个程序，以对其进行深入分析、生成有关它的报告，等等。
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.
收集这些统计信息后生成的查询访问计划与示例3中的最后的计划相同。
The query access plan produced after collecting these statistics is the same as the final plan in Example 3.
生成分布统计信息意味着给DB 2带来额外的、可观的开销，从而影响RUNSTATS命令的执行时间。
Generating distribution statistics means a significant, additional expense for DB2 and, therefore, influences the execution time of the RUNSTATS command.
收集数据分布的统计信息，然后再次生成访问计划。
Collect distribution statistics and then generate the access plan again.
而一旦生成了关于“TYPE”列的分布统计信息，优化器即可了解每种型号真正的出现频率。
When distribution statistics are generated for the column "TYPE," the optimizer knows the real frequency of each model.
总而言之，如果有可用的XML统计信息，DB 2可以生成更好的执行计划。
In a nutshell, the DB2 does generate better execution plans if XML statistics are available.
我曾使用该功能来生成下载页面、目录(当文档跨多个不同文件时)、统计信息及更多其它内容。
I have used this feature to generate download pages, tables of contents (when a document is spread across different files), statistics, and much more.
既然了解了如何访问和分析运行Geronimo的某个示例Web应用程序时生成的JVM统计信息，就可以开始分析自己的应用程序了。
Now that you've seen how to access and analyze the JVM statistics generated when running one of Geronimo's sample Web applications, you can start analyzing your own applications.
如果编译环境或表统计信息在explain语句执行时已经发生改变，那么编译器可能会生成一个不同的访问计划。
If the compilation environment or table statistics have changed when the explain statement is issued, the compiler may generate a different access plan.
和上面提到的实用工具不同，db 2提供了db 2move实用工具来将全部数据从一个数据库移动到另一个数据库，db2look实用工具可以生成ddl和统计信息。
Other than the above mentioned utilities, db2 provides the db2move utility to move the entire data from one database to another, and db2look to generate the DDLs and statistics.
Design Advisor生成的输出文件包含一组ddl语句，用于创建MQT、刷新和更新MQT上的统计信息，以及在其上创建索引。
The output file generated by the Design Advisor contains a set of DDL statements that create MQTs, refresh and update statistics on the MQTs, and create indexes on them.
为第一篇文章开发的初始应用程序增加了统计信息收集器消息bean和用于生成实体标识符的交叉事务。
The original application developed for the first article was enhanced with a statistics collector message bean and interleaved transactions for generating entity identifiers.
获得JVM生成的统计信息之后，您可以访问Geronimo的JVM并分析您的应用程序。
After you've gotten to the statistics generated by the JVM, you can access Geronimo's JVM and analyze your applications.
接下来，为CARS表生成分布统计信息，并再次执行查询。
Next, generate distribution statistics for the table CARS and execute the query again. In this case, the optimizer chooses the following access plan.
所包含的文件Distribution . php包含了为几个常用的抽样分布(t分布、f分布和X平方分布)生成抽样分布统计信息的方法。
The included file, Distribution.php, contains methods that generate sampling-distribution statistics for several commonly used sampling distributions (Student t, Fisher f, Chi Square).
特殊页面常用来生成信息，不管信息是从数据库还是其他资源检索而来，在本文中就制作了一个特殊页来显示系统的某些统计信息。
Special pages are often used to generate information, whether retrieved from a database or other source, so you made one that displays some of the system's statistics.
这显示了有关用于生成建模统计数据的扩展内存大小的具体信息。
This displays details about the size of expanded memory that is used to produce the modeled statistics.
所以，应该只为那些需要分布统计信息的列生成分布统计信息。
So restrict generating distribution statistics to those columns that require distribution statistics.
统计信息配置文件是自动生成的，自动统计信息收集过程将用它来调度RUNSTATS。
A statistics profile is generated automatically for use by the automatic statistics collection process to schedule RUNSTATS.
从数据库中生成结果的统计信息。
对网站的用户生成匿名统计以提高网站使用性能或向第三方发送统计信息。
Generate anonymous statistics of users of the website, to improve the website, or convey statistical information to third parties.
实验基于语言学启发信息生成次范畴化框架假设，然后应用统计方法进行假设检验。
The hypotheses for subcategorization frames are generated by means of linguistic heuristic information and tested via statistic methods.
个体税收定位定税计算机管理信息系统由定位管理子系统、定额生成子系统、查询统计分析子系统、系统设置子系统和数据接口子系统五个部分组成。
The system is made up of tax orientation management sub system, tax amount generate sub system, query, statistic and analysis sub system, system configuration sub system and data interface sub system.
通过对我国企业统计核算数据要求的分析，提出了ERP系统中的统计核算信息生成模型。
This paper puts forward the generation model of statistics accounting information in ERP system by analyzing the data request of China's enterprise statistics accounting.
通过对我国企业统计核算数据要求的分析，提出了ERP系统中的统计核算信息生成模型。
This paper puts forward the generation model of statistics accounting information in ERP system by analyzing the data request of China's enterprise statistics accounting.
应用推荐