Plan query is working but it doesn't display. I tested it with Oracle but I see the same code for DB2, other DBMS I didn't check.
There is bad use of swt/jface.
If somebode interested let me give the fix to CVS.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The DB2 explain plan definitely works in the latest version. What version of eclipse and what version of sql explorer are you using?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
-
2012-01-03
I use Eclipse 3.7.1. I tested latest plugin version downloaded last week and CVS HEAD version which i checked out yesterday. I tested Explain plan for Oracle.
The main error is missing use of setControl method of CTabItem class in ExplainExecution.java.
There are also some extra lines - wraping to extra Composite - that can be avoided. Also changing of layout data of parent looks strange and it can be avoided. I can send working code.
I'would also appreciate to show bytes column next to cost and cardinality.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Plan query is working but it doesn't display. I tested it with Oracle but I see the same code for DB2, other DBMS I didn't check.
There is bad use of swt/jface.
If somebode interested let me give the fix to CVS.
The DB2 explain plan definitely works in the latest version. What version of eclipse and what version of sql explorer are you using?
I use Eclipse 3.7.1. I tested latest plugin version downloaded last week and CVS HEAD version which i checked out yesterday. I tested Explain plan for Oracle.
The main error is missing use of setControl method of CTabItem class in ExplainExecution.java.
There are also some extra lines - wraping to extra Composite - that can be avoided. Also changing of layout data of parent looks strange and it can be avoided. I can send working code.
I'would also appreciate to show bytes column next to cost and cardinality.
I was able to get explain plans out of Orcle using this:
EXPLAIN PLAN for
select ...;
select * from table(dbms_xplan.display);