| Subject | Re: [firebird-support] View plan without executing query? |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-02-21T11:08:35Z |
At 11:40 AM 21/02/2005 +0100, you wrote:
SET PLANONLY ON;
and then run the query.
SET PLANONLY OFF;
to switch it off.
Most of the GUI tools that allow you to prepare a query before running it
will show you the plan upon preparing, e.g. IB_SQL.
/hb
>Is there a way to view the (estimated?) plan without actually executingIn isql, use the command
>the query?
SET PLANONLY ON;
and then run the query.
SET PLANONLY OFF;
to switch it off.
Most of the GUI tools that allow you to prepare a query before running it
will show you the plan upon preparing, e.g. IB_SQL.
/hb