Oracle 11g 分区表收集统计信息 使用INCREMENTAL

在11g中，数据库可以增量维护global统计信息，通过仅扫描那些有一定比例数据发生变化的分区，其他分区仍然使用老的统计信息。

about INCREMENTAL option:

INCREMENTAL

Determines whether the global statistics of a partitioned table will be maintained without doing a full table scan.

INCREMENTAL - This value determines whether or not the global statistics of a partitioned table will be maintained without doing a full table scan. With partitioned tables it is very common to load new data into a new partition. As new partitions are added and data loaded, the global table statistics need to be kept up to date. Oracle will update the global table statistics by scanning only the partitions that have been changed instead of the entire table if the following conditions hold:

• the INCREMENTAL value for the partitioned table is set to TRUE;

• the PUBLISH value for the partitioned table is set to TRUE;

• the user specifies AUTO_SAMPLE_SIZE for