Re: Query plan

[Thomas Krogsæter <db@xxxxxxxxxxxxx>]

Hi,
another few plan question:
is it possible to see, if an index is used during evaluation?

Is McKoi using pipelined evaluation?

Regards,
Thomas

----- Original Message ----- 
From: "Tobias Downer" <toby@mckoi.com>
To: <mckoidb@mckoi.com>
Sent: Saturday, May 03, 2003 11:12 PM
Subject: Re: Query plan


> Thomas Krogsæter wrote:
> > Hi,
> > is it possible to see a query plan of a SQL-statement? I think of
something
> > like EXPLAIN in Oracle.
>
> If you set 'debug_level' to 10 or below then the query plan of all
> queries executed will be written to the log file.  The query plan string
> is a little difficult to decode and doesn't contain all the information
> about the plan but does give a detailed overview of what the engine is
> doing to solve the query.
>
> Toby.
>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
>