Re: [PERFORM] Performance regression 8.3.8 -> 8.4.1 with NOT EXISTS

usual answer - use LEFT JOIN luke.

Re: [PERFORM] Performance regression 8.3.8 -> 8.4.1 with NOT EXISTS

Wiktor Wodecki writes: > As you can see the 8.4 run is 16 times slower. It was even worse before > we added the index idx_b_b_date which we didn't have initially. > Is there anything we can do about this issue? Do you need more information? You could prevent flattening of the EXISTS subquery by a