Subject Re: [firebird-support] query speed - confusing
Author Anderson Farias
Hi,

>I thought it would be selecting all rows that meet the criteria, then
>sorting to determine the first 25

It would perhaps take this rout *IF* your WHERE clause were eficient. BUT,
since FB can't use any index from your WHERE clase than sorting first looks
like the best choice.

Again, FIX your where clause/indexes so both query can be more efficient


Regards,
Anderson