Subject Re: Limiting fetched rows doesn't offer much performance benefit
Author jimbehr3446
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > as I say - the workaround is to use an order by clause. it's simple
>
>
> and I mean order by PK (not the flag field)
>
Could you explain how adding an ORDER BY PK will allow FB to not scan
the entire matching record set?