Hi Karol, Thanks for your reply.
Can you outline how I would do a "inner join to pseudo inner join without affecting resultset". Matthias On Wed, Mar 4, 2020 at 10:12 AM liviuslivius liviusliv...@poczta.onet.pl [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > Hi > > You can always change inner join to pseudo inner join without affecting > resultset. > > But better you should find the reason of this slowdown as it looks like > index without recent stats or wrong indexing in join. But it also can be > something else. > > Regards, > Karol Bieniaszewski > > >