Alternative ways of collecting catalog statistics.
收集目录统计信息的可供选择的方法。
Example 3: Collect catalog statistics on key columns
示例3：收集关键列上的目录统计信息
Example 36. To collect basic index catalog statistics.
收集基本的索引目录统计信息。
Example 37. To collect extended index catalog statistics.
收集扩展的索引目录统计信息。
Example 8: Collect catalog statistics on all indexes only.
示例8：只收集所有索引上的目录统计信息。
Example 14. Collect catalog statistics with distribution.
收集包含分布统计信息的目录统计信息。
Example 2: Collect catalog statistics on individual column names.
示例2：收集单个列上的目录统计信息。
Example 34. Collect catalog statistics for a schema using REORGCHK
使用 REORGCHK收集一个模式的目录统计信息
Example 19: Collect catalog statistics that capture column groups.
示例19：收集捕获了列组的目录统计信息。
Catalog statistics are also collected for two indexes IDX1 and IDX2.
并且还为两个索引idx1和IDX2收集目录统计信息。
Example 11: Collect catalog statistics on selected columns with distribution.
示例11：收集选定列中包含分布的目录统计信息。
If the catalog statistics are inaccurate, get them up to date with RUNSTATS.
如果编目统计数据不准确，应该使用RUNSTATS更新它们。
Example 4: Collect catalog statistics on key columns and on one column that is not.
示例4：收集关键列上和一个非关键列上的目录统计信息。
Example 21: Register a statistics profile only without collecting catalog statistics
示例21：只注册一个统计信息配置文件，不收集目录统计信息
Example 7: Collect catalog statistics on 3 specific indexes only (no table statistics).
示例7：只收集3个指定索引上的目录统计信息(不含表统计信息)。
Example 26: Collect catalog statistics using a previously registered statistics profile.
示例26：使用前面已注册的统计信息配置文件收集目录统计信息。
Catalog statistics can become stale over time as changes to the table and the data occur.
一段时间之后，随着表和数据发生更改，目录统计信息可能会过时。
I'll discuss this method in the section Alternative ways of collecting catalog statistics.
我将在收集目录统计信息的备选方法小节中讨论该方法。
Example 9: Collect catalog statistics on the table and indexes with distribution statistics
示例9：收集表和索引上的目录统计信息，包含分布统计信息
Example 23: Modify an existing statistics profile only; no catalog statistics are collected.
示例23：仅修改现有的统计信息配置文件，不收集任何目录统计信息。
Example 18: Collect catalog statistics on all indexes and on columns deptno and deptname.
示例18：收集所有索引以及列deptno和deptname上的目录统计信息。
Example 5: Collect catalog statistics on the table and indexes without distribution statistics.
示例5：收集表和索引上的目录统计信息，不包含分布统计信息。
Example 17: Collect catalog statistics on all indexes and on column deptname with distribution.
示例17：收集所有索引上的目录统计信息，包含列deptname 上的分布统计信息。
Example 38. To collect extended index catalog statistics specifying that sampling should be used.
收集扩展的索引目录统计信息，指定使用抽样。
Example 35. Collect catalog statistics using the LOAD command and the statistics use PROFILE clause.
使用LOAD命令和STATISTICSUSEprofile子句收集目录统计信息。
Example 20: Collect catalog statistics on all columns and LIKE statistics on a specific VARCHAR column.
示例20：收集所有列上的目录统计信息并指定varchar列上的LIKE统计信息。
The following example illustrates using RUNSTATS to collect catalog statistics that capture LIKE statistics.
下列例子说明了如何使用RUNSTATS收集捕获了LIKE统计信息的目录统计信息？
Example 16: Collect catalog statistics on table, with distribution statistics on columns deptno and deptname.
示例16：收集表上的目录统计信息，包含列deptno和deptname上的分布统计信息。
The following example illustrates using RUNSTATS to collect catalog statistics that capture column group information
下列例子说明了如何使用RUNSTATS收集捕获了列组信息的目录统计信息
When there is any data modification to the user tables, the catalog statistics tables are not automatically modified.
当用户表中发生数据修改时，目录统计信息表不会自动被修改。
应用推荐