Re: Hint for self-join connect by

I think Amit was asking for the "filter predicates" section at the end of the explain plan ;)

By the way, have you tried collecting statistics at 100%, to see whether that makes any difference ?

How many rows (starting rows) with acct_id = '_MERGED_' there are in the tables - a few, many, almost all ?

On 4/30/07, Herring Dave - dherri <Dave.Herring_at_acxiom.com> wrote:
> Yup:
>
> DEFINE ACCT_MERGE='_MERGED_';
>
> Dave
> ___________________________________
>
> David C. Herring, DBA | A c x i o m Delivery Center Organization
>
> 630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
>
>
> > -----Original Message-----
> > From: amit poddar [mailto:amit.poddar_at_yale.edu]
> > Sent: Monday, April 30, 2007 4:12 PM
> > To: Herring Dave - dherri
> > Cc: oracle-l
> > Subject: Re: Hint for self-join connect by
> >
> > Can you post the predicate information from the explain plan ?
> >
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
> ****************************************************************************
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Alberto Dell'Era
"dulce bellum inexpertis"
--
http://www.freelists.org/webpage/oracle-l