Sorry I can't help at all, Kjell, I'm all "old style query plan". Though I'm baffled by the new style changing when the old style remains and would love if someone could explain...
Set fre. 1. mai 2020 kl. 11:56 skrev Karol Bieniaszewski [email protected] [firebird-support] < [email protected]>: > > > You can try also pseudo inner join (left join with where clause) > > > > Instead of > > > > T1 INNER JOIN T2 ON T1.ID1=T2.ID2 > > > > change it to > > > > T1 LEFT JOIN T2 ON T1.ID1=T2.ID2 > > WHERE > > T2. ID2 IS NOT NULL > > > > regards, > > Karol Bieniaszewski > > >
