Subject Re: [firebird-support] Re: View plan without executing query?
Author Kjell Rilbe
Hi Adam,

Yes, I've been using "first 1" for that purpose on select queries. But
it doesn't work for count(*) queries. On the other hand, perhaps the
plan is the same for "select count(*)" and "select *"?

Kjell

Adam wrote:

> Another possible way is to use the keywords:
>
> First 0
>
> This will obviously still execute the query, but it should be pretty
> fast because it doesn't actually fetch any rows.
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64