| Subject | Re: Limiting fetched rows doesn't offer much performance benefit |
|---|---|
| Author | jimbehr3446 |
| Post date | 2006-03-07T21:12:56Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
matching records just to return the FIRST n. Using an ORDER BY clause
forces that situation. Without an ORDER BY clause, FB should not need
to fetch all of the matching records.
>But we are trying to avoid waiting for FB to build the list of all
> if order is unimportant - then use an ORDER BY clause!!!
>
matching records just to return the FIRST n. Using an ORDER BY clause
forces that situation. Without an ORDER BY clause, FB should not need
to fetch all of the matching records.