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
Dear list,
We have databases with rather large tables, and we do bulk queries on them,
i.e. those queries always have a large result set.
We execute those queries with enable_nestloop set to false, because having
nested loops in those queries always cause large performance issues. This
usually lea
