Subject | Re: [firebird-support] query speed - confusing |
---|---|
Author | Anderson Farias |
Post date | 2009-08-12T14:30:19Z |
Hi,
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
>I thought it would be selecting all rows that meet the criteria, thenIt would perhaps take this rout *IF* your WHERE clause were eficient. BUT,
>sorting to determine the first 25
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