Cardinality feedback tuning

Wolfgang Breitling has proposed cardinality feedback tuning method and it works very well for Oracle.
I have to agree with him that it would be nice if Oracle can automatically apply this method. Whenever the optimizer sees an intermediate cardinality to be drastically different than the query plan as defined below, it should retry with a different plan that produces such a cardinality or close:
1. 0 to non-0, or vice versa.
2. 1 to 1+, or vice versa.
3. n to 100n, (or a threshold that can be set by user), or vice versa.

I don’t see it in 11g though, but that will be the ultimate feature and perhaps the end of Oracle performance tuning consultancy.

Advertisements

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


%d bloggers like this: