--- In firebird-support@yahoogroups.com, "akdatilla" <akdatilla@...> wrote:

>
> Hi,
> We have a problem about firebird database. The following sql text run in the sqlserver database for 2-3 seconds. But in the firebird database this sql run for 25 minutes. How can we run this sql query quickly in the firebird.
> Could you help to us for this problem.
> Best Regards.
>
> Sql:
>

If you replace

SHB_ID=(
SELECT FIRST 1 SHB_ID FROM SHRKSTR AS ST1,SHRKBSLK AS ST2,SHRKTNM AS ST3
WHERE SYMSFB.SHB_SDP=ST1.SHB_SDP AND ST1.SHB_SHA=ST2.SHA_ID AND
ST2.SHA_SHT=ST3.SHT_ID AND ST3.SHT_ISLTIPI=4 AND ST2.SHA_SEVKTRH
BETWEEN '01.01.2009' AND '31.12.2009' AND
SYMSFB.SHB_STK=ST1.SHB_STK ORDER BY ST2.SHA_SEVKTRH DESC)

with

SHB_ID=0 (or SHB_ID = '0')

what do you get ?


Regards,
Zlatko