Subject | Get execution plan through JDBC |
---|---|
Author | |
Post date | 2014-03-02T22:01:18Z |
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
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