Can I see an SQL execution plan through a JDBC connection 
Author Message
 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
 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
 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
 
 [ 3 post ] 

 Relevant Pages 

1. Efficient reuse of execution plan using JDBC

2. Efficient reuse of execution plan using JDBC

3. Execution plan,Query plan?

4. Stored proc/SQL execution plan differs with same SQL

5. Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000

6. Sql Server Query Analyzer Execution Plan

7. Trying to compile an execution plan w/ SQL 7.0

8. Bug in sql analyser, execution plan shows always 0

9. SQL Server execution plan for tables in another database

10. Dynamic SQL, Coalesce, Stored Procs execution plans and cost

11. SQL Execution Plan

12. SQL Server 7 query analyzer: the execution plan


 
Powered by phpBB® Forum Software