Subject RE: [firebird-support] Re: SQL Case query takes 4 minutes 30 seconds to execute !!
Author Leyne, Sean
> No it should only return 1 line but even with “and jtype = j.jtype” added to
> the subselect condition it still takes almost 5 minutes to return data

Please provide the PLAN for the statement and the details of indexes defined for the queries tables.