Re: Suboptimal query plan with connect by

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 29 Oct 2018 14:23:55 +0100
Message-ID: <c80826ce-6ce3-6764-3b66-c47d96fe07cf_at_gmail.com>


On 29/10/2018 14:17, Lothar Flatz wrote:
> 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

Thank you Lothar!
I'll try your solution with the pipelined function.

Regards
Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 29 2018 - 14:23:55 CET

Original text of this message