IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
IDS now automatically collects index statistics on the leading index key while the index is being created.
该命令的输出会展示出每个分区的数据和索引统计信息,并针对需要重组的分区提供建议。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
本例中,10%的表数据页用于表统计信息的收集,而对于索引统计信息,将使用所有的索引页。
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.
在Cheetah (IDS11)中,当创建索引时,IDS自动收集起始索引键上的索引统计信息。
In Cheetah (IDS 11), IDS automatically collects index statistics on the leading index key while the index is being created.
远程数据源上通常不提供关于一个视图的索引或统计信息。
There is usually no index or statistics information provided at the remote data source on a view.
它会检查DB 2目录以获取有用的统计信息,并看看哪些索引可用。
It will check the DB2 catalog for useful statistical information and to see what indexes are available.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
有关索引的统计信息,比如索引级别的数量和每个索引中叶子页的数量。
Statistics about the index such as the number of index levels and the number of leaf pages in each index.
该工具不仅可用于获得关于各种不同网格大小的建议,还可以用于收集一个已有的或计划中的(虚)索引的统计信息。
The tool cannot only be used to get Suggestions for the various grid sizes but also to collect statistics of an existing or planned (virtual) index.
在我们对基准的第一个改进中,我们向账单表增加索引,并为表更新统计信息。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
昵称可以包含列、统计信息、索引或信息约束。
Nicknames can have columns, statistics, indexes, or information constraints.
但是在某些情况下,在创建昵称之后,可能需要添加索引信息和统计信息,以便让优化器下推与昵称一起使用的谓词。
But in some cases, it may be necessary to add index information and statistics to the nickname after it is created in order to get the optimizer to push down predicates used with the nickname.
应用程序准备(编译)好一条语句之后,可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
不过,最好是在创建索引之后再执行LOAD命令,并在LOAD期间收集统计信息。
However, it is preferable to create indexes before performing the LOAD command, and collecting statistics during the LOAD.
其次,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.
DB 2定期检查已经更新其统计信息的表和索引,判断它们是否需要重组,当需要时安排执行这些操作。
DB2 determines if a table or index reorganization by periodically checking tables and indexes that have had their statistics updated, and schedules such operations whenever they are necessary.
通常,执行RUNSTATS时,不但可以收集到关于表的统计信息,而且还可以收集到相应的索引的相关统计信息。
In general, when executing RUNSTATS, statistics are not only collected for a table, but are also collected for the corresponding indexes.
例如,它周期性地自动执行RUNSTATS实用程序,以更新关于表及相关索引的物理特征的统计信息。
For example, it automatically executes the RUNSTATS utility on a periodic basis to update statistics about the physical characteristics of a table and the associated indexes.
并且还为两个索引idx1和IDX2收集目录统计信息。
Catalog statistics are also collected for two indexes IDX1 and IDX2.
在表的LOADREPLACE期间以及索引的创建期间,也可以进行目录统计信息的收集。
Collecting catalog statistics can also be issued during a LOAD REPLACE of a table, as well as during the creation of an index.
收集两个索引上的详细目录统计信息,但对每个索引条目使用抽样来代替执行详细的计算。
Example 27. Collect detailed catalog statistics on both indexes, but use sampling instead of performing detailed calculations for each index entry.
下列RUNSTATS示例收集基于索引的所有可能统计信息。
The following RUNSTATS example collects all possible statistics based on the indexes.
在employee表和它的新的及剩余的索引上再次收集统计信息。
Statistics are re-collected on the EMPLOYEE table and its new and remaining indexes.
示例8:只收集所有索引上的目录统计信息。
下面的RUNSTATS命令只收集cars表(在模式sample中)和相应索引的基本统计信息。
The following RUNSTATS command collects only the basic statistics for the table CARS (in schema SAMPLE) and the corresponding indexes.
提示11:使用RUNSTATS收集XML数据和索引的统计信息。
Tip 11: Use RUNSTATS to collects statistics for XML data and indexes.
收集扩展的索引目录统计信息。
收集扩展的索引目录统计信息,指定使用抽样。
Example 38. To collect extended index catalog statistics specifying that sampling should be used.
RUNSTATS实用程序已经被扩展,现在可以收集关于XML数据和xml索引的统计信息。
The RUNSTATS utility has been extended to collect statistics on XML data and XML indexes.
应用推荐