Re: Tuning one Recurcive CTE

Hi,

I will need to anonymized before sending it.
Do you know if there is any tuning documents related to CTE scans

//H

På onsdag 09. november 2016 kl. 14:05:55, skrev Henrik Ekenberg <henrik@ekenberg.pw>:

Hi,

I try to tune one Recursive CTE.

Explain Plan can be found here
https://explain.depesz.com/s/yLVd

Anyone can give me direction to check?

//H.

 

Rule number one; Always provide the query in question when asking for help tuning it.

 

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@visena.com

www.visena.com