Subject Re: [Firebird-Java] Get execution plan through JDBC
Author Ray Holme
use isql
show plan;

On Sun, 2014-03-02 at 14:01 -0800, IJFQSFTGESJU@... wrote:
>
> Hello,
> how can I get the execution plan of a query through JDBC (using
> Jaybird & Firebird)?
>
> In Postgres or Oracle I can simply run "explain" and get a ResultSet
> back when using executeQuery().
> As far as I can tell there is no "explain" or "explain plan" in
> Firebird, so how can I retrieve the execution plan for an arbitrary
> SQL statement (available as a String)?
>
> Thanks
> Thomas
>
>
>