Re: Suboptimal query plan with connect by

Hi,

you could use this technique:

https://oracleriddleblog.wordpress.com/2015/03/23/solution-navigate-many-shallow-hierachies-in-parallel/ It will also show you an other hidden parameter. Make sure the indexes are in place!

Regards

Lothar

Am 29.10.2018 um 14:12 schrieb Radoulov, Dimitre:
>
> 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
>
>

-- 




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