Re: New Feature: "Cost Based Transformation"

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Sep 2005 06:10:01 -0700
Message-ID: <1125666601.661361.58920@g49g2000cwa.googlegroups.com>

Matt, have you read the following article: Understanding Optimization by Kimberly Floss at
http://www.oracle.com/technology/oramag/oracle/05-jan/o15tech_tuning.html

>From several article posted on the Internet it would appear that
pushing predicates and start transformations qualify as being "cost based transformations".

I do not think technically it is a new feature so much as the fact that the CBO is now capable of more of them and on basing the decisions on system statistics rather than IO estimates.

HTH -- Mark D Powell -- Received on Fri Sep 02 2005 - 08:10:01 CDT