Oracle Logbook

September 11, 2007

Understanding System Statistics

Filed under: Uncategorized — Helio Dias @ 8:50 pm

by Jonathan Lewis

Understanding the optimizer’s use of system statistics can make a big difference when migrating to a new version of the Oracle Database.

What is the most important component of the Oracle Database engine? My vote goes to the optimizer. Everything the database does is SQL, and every piece of SQL has to be translated into something that can work efficiently. Whatever you do with your data, the optimizer gets involved.

http://www.oracle.com/technology/pub/articles/lewis_cbo.html

Leave a Comment »

No comments yet.

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: