Re: Suboptimal query plan with connect by

On 29/10/2018 14:03, Sayan Malakshinov wrote:
> Hi Dimitre,
>
> Since your predicates in where clause are not join predicates, they
> are executed AFTER "connect by" and they work just filters for the
> tree, so your first and second queries are not equal to each other.
>

Thank you very much Sayan!
So I imagine that in this context an index and a selective filter would not help.

I know that the parallel execution could be quite complex but have you ever had problems with hierarchical queries and parallelism?

Regards
Dimitre

--
http://www.freelists.org/webpage/oracle-l