Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: New Feature: "Cost Based Transformation"
mccmx_at_hotmail.com wrote:
> Anyone heard of this new feature in 10g: "Cost Based Transformation".
>
> Its basically new functionality which enables the optimizer to cost
> transformation operations like subquery unnesting and predicate pushing
> etc.
I don't understand this concept. Whatever access path is implied by your query-as-written, should still be among the legitimate access paths for the query after it is unnested. So how would it be possible/meaningful for an unnesting not to be costed? It seems like costing the unnesting is an implicit part of the CBO.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Fri Sep 02 2005 - 14:27:37 CDT