SYSSTAT views containing the table, column, and index statistics.
SYSSTAT视图,包含表、列和索引统计数据。
IDS now automatically collects index statistics on the leading index key while the index is being created.
IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
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.
该命令的输出会展示出每个分区的数据和索引统计信息,并针对需要重组的分区提供建议。
The functions for gas load forecast and index statistics of the system are discussed in combination with engineering example.
结合工程实例,论述了系统的燃气负荷预测和指标统计功能。
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 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.
用户只收集一部分数据可能会造成不一致的统计数据,例如,在不同时间分别收集表和索引统计数据。
Statistics about the index such as the number of index levels and the number of leaf pages in each index.
有关索引的统计信息,比如索引级别的数量和每个索引中叶子页的数量。
There is usually no index or statistics information provided at the remote data source on a view.
远程数据源上通常不提供关于一个视图的索引或统计信息。
The National Bureau of Statistics has said it is actively studying ways to improve the consumer price index.
国家统计局已经表示,正积极研究如何完善居民消费价格指数统计体系。
This includes information about establishing connections to the data source, remote server attributes, data type and function mappings, index information, and remote object statistics.
这包括关于建立到数据源的连接的信息、远程服务器属性、数据类型和函数映射、索引信息以及远程对象统计信息。
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.
该工具不仅可用于获得关于各种不同网格大小的建议,还可以用于收集一个已有的或计划中的(虚)索引的统计信息。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
This means that you should either load your data prior to creating your index or update the statistics on your table after your data is loaded.
这意味着您应该在创建索引之前加载数据,或者在加载数据之后更新表的统计信息。
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.
但是在某些情况下,在创建昵称之后,可能需要添加索引信息和统计信息,以便让优化器下推与昵称一起使用的谓词。
With the step-by-step analysis on statistics, predicate, and index, the performance of the problem query is improved significantly.
通过对统计数据、谓词和索引的逐步分析,问题查询的性能大幅提升。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
"In other words, according to the Big Mac index China official price statistics are, well, just as accurate as anyone else's," Anderson said.
“换言之,根据巨无霸汉堡包指数,中国官方的价格统计数据与其它经济体同样准确,”安德森表示。
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.
DB 2定期检查已经更新其统计信息的表和索引,判断它们是否需要重组,当需要时安排执行这些操作。
If the catalog statistics are up to date and DB2 knows that a particular index is poorly organized, DB2 may decide not to use it.
如果编目统计数据是最新的,而DB 2知道某个索引组织得不好,DB 2就可能决定不使用它。
The first batch of statistics is expected to be officially released before the end of 2007. China’s first official index system for E-commerce statistics is under construction.
目前正与中国国家统计局联合开展电子商务统计,第一批统计数据预计在2007年年底前可正式对外发布,中国第一个权威的电子商务统计指标体系正在逐步形成。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性,它表示收集统计数据的时间。
Example 27. Collect detailed catalog statistics on both indexes, but use sampling instead of performing detailed calculations for each index entry.
收集两个索引上的详细目录统计信息,但对每个索引条目使用抽样来代替执行详细的计算。
In DB2, the command RUNSTATS TABLE all INDEX all collects all uniform statistics, many of which may not be necessary for improving query performance.
在DB 2中,RUNSTATS TABLEALLINDEX ALL命令会收集统一的统计数据,这其中很多对改善查询性能并不必要。
With the new index created, and statistics collected on it, the optimizer corrects the cardinality estimate of the query access plan.
然后优化器会使用新创建的索引和在其上收集的统计信息来更正查询访问计划的基数估计值。
Example 36. To collect basic index catalog statistics.
收集基本的索引目录统计信息。
Example 13: Collect catalog statistics with distribution on all columns that are part of the index, plus two columns that are not.
示例13:收集构成索引的所有列以及两个非索引列中包含分布的目录统计信息。
Example 37. To collect extended index catalog statistics.
收集扩展的索引目录统计信息。
应用推荐