>> select fieldA, fieldB from table1
>> where (fieldA starting with 'bd'
>> or fieldA starting with 'bi')
>> and fieldA between 'bd' and 'bj')
>> order by fieldA asc, fieldC asc
>>
>> Thanks, will try that out and report back.
>> I started to use the union instead of the OR when we
>> were still on Interbase and the difference in speed then was enormous. We then
>> moved to Firebird and the difference was still there.
>> Note that we are still on Firebird 1.5 if that makes a difference.
>
> Could be, because the V2 series offers a lot of improvements in the
> optimizer area.
>
> If possible, I would seriously try that with Firebird 2.5.

... needless to say, after migrating the database with a backup/restore
cycle to pump the ODS to the newest version.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/