SYSSTAT views containing the table, column, and index statistics.
SYSSTAT视图,包含表、列和索引统计数据。
In Cheetah (IDS 11), IDS automatically collects index statistics on the leading index key while the index is being created.
在Cheetah (IDS11)中,当创建索引时,IDS自动收集起始索引键上的索引统计信息。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
该命令的输出会展示出每个分区的数据和索引统计信息,并针对需要重组的分区提供建议。
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%的表数据页用于表统计信息的收集,而对于索引统计信息,将使用所有的索引页。
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.
由于每个索引(片段)都有自己的udi计数器,因此将根据索引(片段)的修改程度判断是否跳过或是重建索引统计。
The functions for gas load forecast and index statistics of the system are discussed in combination with engineering example.
结合工程实例,论述了系统的燃气负荷预测和指标统计功能。
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.
对于索引统计数据的更新将失败,并发出 SQL1227Nrc=8错误消息(本例中),因为索引的FIRSTKEYCARD大于表的CARD。
Inconsistent statistics may be caused when users collect the partial statistics, for example collecting table and index statistics individually, at different points in time.
用户只收集一部分数据可能会造成不一致的统计数据,例如,在不同时间分别收集表和索引统计数据。
Inconsistent statistics may be caused when users collect the partial statistics, for example collecting table and index statistics individually, at different points in time.
用户只收集一部分数据可能会造成不一致的统计数据,例如,在不同时间分别收集表和索引统计数据。
应用推荐