Subject Re: [firebird-support] Execution plan
Author Alexandre Benson Smith
frederic.hoornaert wrote:

>Sorry if this has been asked before, but I haven't found the
>yet, so I'll hope you guys can help me out.
>Sybase and Oracle database provide SQL Statements or functions to
>get the
>Execution plan of a query.
>Sybase : select plan('query') from dummy
>FireBird doesn't seem to have a integrated function which does, but
>newsgroup threads say this is available through an API call.
>Anyone knows the name & defintion of the API function that's used to
>get the
>execution plan ?
> Sample code ?
>Could this be easily integrated in a C++ DLL and use it as an UDF so
>that it
>can be used in the same way as SQL Anywhere ?
>Example :
>select plan('select x from y') from rdb$database.
>Kind regards,
>Frederic Hoornaert
As you know it is available trough API.

The client tools (such ISQL, IBExpert, Database Workbench,, FalmeRobin
and so on) all show you the plan, some in a very easy to understand form.

are you asking how to know what plan is used on the general tools, or
how to get it from inside your app ?

If the later, it will depend on the access componentes you are using.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil