SYSSTAT视图,包含表、列和索引统计数据。
SYSSTAT views containing the table, column, and index statistics.
IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
IDS now automatically collects index statistics on the leading index key while the index is being created.
本例中,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.
该命令的输出会展示出每个分区的数据和索引统计信息,并针对需要重组的分区提供建议。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
用户只收集一部分数据可能会造成不一致的统计数据,例如,在不同时间分别收集表和索引统计数据。
Inconsistent statistics may be caused when users collect the partial statistics, for example collecting table and index statistics individually, at different points in time.
在Cheetah (IDS11)中,当创建索引时,IDS自动收集起始索引键上的索引统计信息。
In Cheetah (IDS 11), IDS automatically collects index statistics on the leading index key while the index is being created.
由于每个索引(片段)都有自己的udi计数器,因此将根据索引(片段)的修改程度判断是否跳过或是重建索引统计。
Since each index (fragment) has its own UDI counter, the decision to skip or rebuild index statistics is done based on how much the index (fragment) has changed.
对于索引统计数据的更新将失败,并发出 SQL1227Nrc=8错误消息(本例中),因为索引的FIRSTKEYCARD大于表的CARD。
The update for the index statistics would fail with a SQL1227N rc=8 error message (in this case) as the FIRSTKEYCARD of the index is greater than CARD of the table.
那些统计数据用于协助索引选择,而不是谓词重排。
Those statistics are used to aid in index selection, not for predicate rearrangement.
远程数据源上通常不提供关于一个视图的索引或统计信息。
There is usually no index or statistics information provided at the remote data source on a view.
如果创建新的索引,而在最后一次执行RUNSTATS以后还未修改相应的表,那么您可以只收集索引上的目录统计信息。
If new indexes have been created, and the corresponding table has not been modified since the last RUNSTATS execution, then you can collect catalog statistics on indexes only.
为了可以对一个表或索引收集统计信息,必须能够连接到包含该表和索引的数据库,并具有下列授权级别之一
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
UPDATESTATISTICSLOW在表和索引上生成的统计将在片段的级别上进行维护。
Statistics generated by UPDATE STATISTICS LOW on tables and indexes have always been maintained at fragment level.
源数据(例如基数或是索引)的标准统计。
Standard statistics from source data (such as cardinality or indexes).
示例5:收集表和索引上的目录统计信息,不包含分布统计信息。
Example 5: Collect catalog statistics on the table and indexes without distribution statistics.
示例9:收集表和索引上的目录统计信息,包含分布统计信息
Example 9: Collect catalog statistics on the table and indexes with distribution statistics
收集索引上的详细抽样统计信息和表的分布统计信息。
Example 28. Collect detailed sampled statistics on indexes as well as distribution statistics for the table.
示例7:只收集3个指定索引上的目录统计信息(不含表统计信息)。
Example 7: Collect catalog statistics on 3 specific indexes only (no table statistics).
统计信息是从所有列(带有分布信息)和所有索引(带有扩展的统计信息)上收集的。
The statistics are collected for all columns (with distributions) and all indexes (with extended statistics).
有关索引的统计信息,比如索引级别的数量和每个索引中叶子页的数量。
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.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
比如,可以在上面创建索引和生成统计结果。
For example, you can now create indexes and generate statistics on them.
应用程序准备(编译)好一条语句之后,可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
昵称可以包含列、统计信息、索引或信息约束。
Nicknames can have columns, statistics, indexes, or information constraints.
通常,执行RUNSTATS时,不但可以收集到关于表的统计信息,而且还可以收集到相应的索引的相关统计信息。
In general, when executing RUNSTATS, statistics are not only collected for a table, but are also collected for the corresponding indexes.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
当使用大型DGTT时,统计数据和索引对于性能是至关重要的。
Statistics and indexes are crucial for performance when large DGTTs are used.
对于本文中的查询,收集了引用表、列、索引的统计数据,如表基数、列基数等等。
For the query in this article, the basic statistics of the referenced tables, columns and indexes were collected, such as the table cardinality, column cardinality, an so on.
应用推荐