Re: Is this SQL transformation possible...?

From: <mccmx_at_hotmail.com>
Date: 18 Oct 2006 01:29:07 -0700
Message-ID: <1161160147.543244.20400@f16g2000cwb.googlegroups.com>

> Collect current statistics

I gathered stats using DBMS_STATS (100%) just before running this query

> Rerun a real explain plan using DBMS_XPLAN and post it.

The provided plan is from DBMS_XPLAN but I cut out sections to make it readable. The format didn't disaply correcty in this newsgroup.

> Needless to say Jonathan Lewis has given sage advice on how to force a
> specific execution plan. A copy of his book on the CBO would be invaluable.
> --

I'm familiar with methods of forcing certain plans but my query is a theoretical question.

Matt Received on Wed Oct 18 2006 - 03:29:07 CDT