More about Incremental Statistics

A few months ago I wrote in a blog post that incremental statistics cannot be combined with a small value for estimate_percent. Because this problem is still an issue for one of my customers (who runs a quite big Data Warehouse) I was looking for some additional information about this subject and found an excellent overview in the blog of Randolf Geist: Incremental Partition Statistics Review. It contains some interesting background information about incremental statistics and its limitations. If you plan to use incremental statistics in your Oracle 11g database, you should read this review summary first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s