Re: connect by clause

Originally posted by Billy Verreynne
> shankar72 wrote
>
> > tried all the things suggested in your mail
>
> How do the explain plans (Test/Dev vs.Prod) look like?
>
> BTW, I find it hard to accept that the _exact_ same data using the
> _exact_ same SQL on two different Oracle databases, can give different
> results.
>
> I will take the SQL, simplify it to its most basic form and run it on
> both and compare the results. And then gradually increase the
> complexity until the difference is hit.
>
> FWIW, I think it must be data. Maybe something as obscure in the way
> NULLS or space are used.. or what character set is selected in the
> init.ora file.
>
> --
> Billy

in development the connect by is executed before the sort, this is not happening in production ... how do i make the connect by happen before the sort.

--
Posted via http://dbforums.com