DB2, Can I see an SQL execution plan through a JDBC connection

Can I see an SQL execution plan through a JDBC connection

Author	Message
Bob McDermo #1 / 3	Can I see an SQL execution plan through a JDBC connection Hi Folks, I am working with a DB2/400 database via a JDBC connection. I have no console access to the database. Is there a way I can see an execution plan through JDBC. I need to analyze a query and it would be very helpful if could see the execution plan. Thanks, Bob
Sun, 08 Aug 2004 21:33:33 GMT

Sailesh Krishnamurth #2 / 3	Can I see an SQL execution plan through a JDBC connection Bob> Is there a way I can see an execution plan through JDBC. I Bob> need to analyze a query and it would be very helpful if could Bob> see the execution plan. I guess you could get the system to populate the EXPLAIN tables and write some queries over the EXPLAIN tables in your JDBC connection. It would be a substantial piece of work ... -- Pip-pip Sailesh http://www.cs.berkeley.edu/~sailesh
Tue, 10 Aug 2004 03:53:37 GMT

Dirk #3 / 3	Can I see an SQL execution plan through a JDBC connection Quote: > Bob> Is there a way I can see an execution plan through JDBC. I > Bob> need to analyze a query and it would be very helpful if could > Bob> see the execution plan. > I guess you could get the system to populate the EXPLAIN tables and > write some queries over the EXPLAIN tables in your JDBC connection. It > would be a substantial piece of work ... That would make some nice project for some student. If we only knew some Ph.D student who could assign that to one of his students and open source it... Dirk
Tue, 10 Aug 2004 05:01:55 GMT

Page 1 of 1

[ 3 post ]