| Subject | Re: CTE is called very often |
|---|---|
| Author | |
| Post date | 2018-06-20T14:44:03Z |
Hi all,
I found out that this happens only with "left outer join".
With left outer join DetailDataForAllPRO selects its data for each PRO --> very slow
With inner join DetailDataForAllPRO selects its data just once. --> very fast, but only PRO with dataildata
Same is true if I try it with a "Derived Table".
Why this happens.
Can I write a statement which works like the left outer join but calls DetailDataForAllPRO just once.
Thank you for your help,
Josef