On 10/10/2025 10:51, Frits Jalvingh wrote:
Hi Andrei,
Thanks a lot for your response. I do not fully get it though because the
well-performing query also references the outer (external?) relation:
-> where eenheid.id_h_eenheid = eenheid_s.id_h_eenheid
But your response made me think a but more.
On 9/10/2025 10:52, Frits Jalvingh wrote:
I do not understand why the simpler query (without the self join)
produces a plan that seems to require nested loops, I hope someone can
explain.
It seems obvious. You have a join clause:
'enheid.id_h_eenheid = huurovereenkomst_s._l_eenheid'
One side o
