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