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>
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-lReceived on Mon Oct 29 2018 - 14:23:55 CET