[firebird-support] Firebird 1.5 Order by Query

Hi, I have a simple query: SELECT first 1 ITEM_DATE FROM HISTORY WHERE ITEM_ID = 'ITEM_ID_123456' and ITEM_TYPE = 'TYPE1' AND ITEM_STATUS > 200 and ITEM_STATUS <> 310 ORDER BY ITEM_DATE ASC Which runs in about 1.5 seconds. If I remove the Order by it's less than 100ms. There are o

RE: [firebird-support] Firebird 1.5 Order by Query

>I have a simple query: > >SELECT first 1 ITEM_DATE FROM HISTORY >WHERE ITEM_ID = 'ITEM_ID_123456' >and ITEM_TYPE = 'TYPE1' >AND ITEM_STATUS > 200 and ITEM_STATUS <> 310 >ORDER BY ITEM_DATE ASC > >Which runs in about 1.5 seconds. If I remove the Order by it's less than >100ms. There are only three

RE: RE: [firebird-support] Firebird 1.5 Order by Query

Yes, thanks, that's made the performance between the two queries comparable again. ---In firebird-support@yahoogroups.com, wrote: >I have a simple query: > >SELECT first 1 ITEM_DATE FROM HISTORY >WHERE ITEM_ID = 'ITEM_ID_123456' >and ITEM_TYPE = 'TYPE1' >AND ITEM_STATUS > 200 and