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.

For example

select first 0 *
from employee

Then you can look at the plan.

Adam



--- In firebird-support@yahoogroups.com, Kjell Rilbe
<kjell.rilbe@a...> wrote:

> Helen Borrie wrote:
> > At 11:40 AM 21/02/2005 +0100, you wrote:
> >
> >>Is there a way to view the (estimated?) plan without actually

executing

> >>the query?
> >
> > In isql, use the command
> >
> > SET PLANONLY ON;
> > and then run the query.
> >
> > SET PLANONLY OFF;
> > to switch it off.
>
> Doesn't work in FlameRobin. Is this a missing feature of FlameRobin or
> why doesn't it work?

>
> Token unknown - line 1, char 5
> PLANONLY
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> Adressmarknaden AM AB
> E-post: kjell.rilbe@a...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64