My queries are very simple and for example rarely have a join. I am not an
expert (not even a novice) on the Firebird optimizer, but with the simple
queries

and after some time I think can make sense of it. Partly, I would like the
FB plan just for completeness as the majority of the queries are SQLite
queries and

these will show (have the option) to show the plan. Not a good reason I
know, but I still think it could be useful. Will have a further go at this
and maybe report

back if I have figured this out.



RBS





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: 25 October 2007 14:02
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Retrieve query plan with SQL?



At 09:48 PM 25/10/2007, you wrote:

>Thanks, I use the Firebird ODBC driver and will try that route.
>I am interested to retrieve the plan in my application (actually it could

be

>done after running the select statement) as my queries are very variable

and

>user defined and I would like to log the plan to see and show the user why
>a particular query was slow. In the same application I use SQLite and with
>that it is simple to get the query plan.

Not quite "apples and apples" there. Rules-based vs cost-based. Even if you
could get the plan at the right time and store it somehow (so far, it sounds
like a long reach), the plan would be meaningless to the user, unless the
user happened to be an expert on the Firebird optimizer...indeed, do you
understand yourself how the Firebird optimizer works?

./heLen





[Non-text portions of this message have been removed]