Subject | Re: [firebird-support] Re: View plan without executing query? |
---|---|
Author | Kjell Rilbe |
Post date | 2005-02-22T13:27:34Z |
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:
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
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