Today I just find out a very nice and useful article about gathering statistic in 10g.
Check it out http://structureddata.org/2008/03/26/choosing-an-optimal-stats-gathering-strategy/
Efficient Statistics Maintenance for Partitioned Tables Using Incremental
Statistics – Part 3
-
Introduction
This post covers how Oracle has improved incremental statistics for
partitioned tables in Oracle Database 12c Release 2. If you’re not alre...
7 years ago