Oracle Logbook

July 23, 2010

Which objects to collect statistics? (Oracle 9i)

Filed under: Uncategorized — heliodias @ 7:12 pm

ALL, for sure is the best answer.

But a client came with the following issue: he was sure that the lack of updated statistics were hurting the performance, and he didn´t have time to collect ALL.

Then I told that he should collect statistics on the smallers objects cause if an object use to have 1.000.000 rows and now have 1.100.000,  probably the otimizer will keep the same execution plan, but for instance and object use to have 2 rows and now have 200, it can change dramatically the performance.

1 Comment »

  1. Hi,

    Wonderful tip. You can collect statistics for only updated tables.

    Comment by Jack Nicholson — September 23, 2010 @ 8:58 pm | Reply


RSS feed for comments on this post. TrackBack URI

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: