Re: Suboptimal query plan with connect by

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: Lothar Flatz <l.flatz@xxxxxxxxxx>
  • Date: Mon, 29 Oct 2018 14:23:55 +0100


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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2018