仅对用户表进行自动统计信息收集。
Only consider user tables for automatic statistics collection.
表范围:确定对哪些表执行自动统计信息收集。
Table scope: Identifies which tables are considered for automatic statistics collection.
当启用自动统计信息配置时,数据库活动的有关信息被收集并存储在查询反馈仓库中。
When automatic statistics profiling is enabled, information about database activity is collected and stored in a query feedback warehouse.
IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
IDS now automatically collects index statistics on the leading index key while the index is being created.
自动统计信息收集是完全自动表维护解决方案的一部分。
Automatic statistics collection is part of a completely automated table maintenance solution.
考虑对所有表进行自动统计信息收集。
自动统计信息收集。
自动表统计信息收集策略。
DB 2自动统计信息收集。
DB 2自动统计信息收集是在DB 2UDBVersion 8.2中引入的。
DB2 automatic statistics collection was introduced in DB2 UDB Version 8.2.
如果为一个昵称收集了统计信息,那么在数据源上对相应远程表的远程统计信息进行更新时,这些统计信息不会自动更新。
Once the statistics are gathered for a nickname, they are not automatically modified when the remote statistics are updated on the data source for the corresponding remote table.
自动统计信息配置则通过确定何时和如何收集统计信息更进了一步。
Automatic statistics profiling goes one step further by determining when and how to collect statistics.
按照本文给出的指导说明,可以高效方便地配置自动备份、自动重组和自动统计信息收集等操作。
Following the instructions outlined in this article, you will be able to configure automatic backup, automatic reorganization, and automatic statistics collection effectively and easily.
统计信息配置文件是自动生成的,自动统计信息收集过程将用它来调度RUNSTATS。
A statistics profile is generated automatically for use by the automatic statistics collection process to schedule RUNSTATS.
下图(只显示统计信息收集和配置选项)展示了统计信息收集和配置的自动维护命令的层次结构和相关性。
The following diagram (only showing the statistics collection and profiling options) shows the hierarchy of automatic maintenance commands for statistics collection and profiling and the dependencies.
在Cheetah (IDS11)中,当创建索引时,IDS自动收集起始索引键上的索引统计信息。
In Cheetah (IDS 11), IDS automatically collects index statistics on the leading index key while the index is being created.
为了设置SAMPLE数据库自动进行统计信息收集,需要为自动维护开关设置数据库配置参数,如下所示。
To set up the SAMPLE database for automatic statistics collection, set the database configuration parameters for automatic maintenance switches as follows.
自动表统计信息收集策略用于控制自动表统计信息收集的行为。
The automatic table statistics collection policy is used to control the behavior of automatic table statistics collection. The following elements are configurable.
自动表统计信息收集策略用于控制自动表统计信息收集的行为。
The automatic table statistics collection policy is used to control the behavior of automatic table statistics collection. The following elements are configurable.
应用推荐