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
Stef van der Merwe From: [email protected] [mailto:[email protected]] Sent: 29 April 2015 12:52 PM To: [email protected] Subject: [firebird-support] Re: SQL Case query takes 4 minutes 30 seconds to execute !! On Wed, 29 Apr 2015 08:39:02 +0200, 'Stef' [email protected] [firebird-support] <[email protected]> wrote: Is it intended, that internal query would return multiple lines with jtype=2 and jtype=99 but sums include both jtypes? Because that is only condition not in included in subselect selecting the sums. -- Virgo Pärna [email protected] [Non-text portions of this message have been removed]
