>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
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