Hi,

Sorry if this has been asked before, but I haven't found the
information
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
Oracle : EXPLAIN PLAN SET STATEMENT_ID = 'PLAN_0001' FOR query

FireBird doesn't seem to have a integrated function which does, but
some
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