--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> Or are you saying that first command is not significantly faster

than second one?

> SELECT FIRST 50 * FROM TABLE WHERE FLAG='Y';
> SELECT COUNT(*) FROM TABLE;
>

That is what we have observed.

Thanks for your comments.