"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:aojh24$e8t$2_at_ctb-nnrp2.saix.net...
> Jan Gelbrich wrote:
>
> > I may not post the Execution Plan,
> > because it is far too long to be realistic (5000++ lines !) - something
> > strange must have happend to my PLAN_TABLE...
>
> Check your join criteria for the explain plan. I'm lazy when it comes to
the
> plan table and only join on statement id as I always use (or try to)
unique
> ones. However, that is not enforced by Oracle. Having one or two explain
> plans with the same statement id and doing the join on id only.. very
> messy. :-)
I always run delete plan_table before an explain plan.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Oct 16 2002 - 06:13:41 CDT
