View Query Plan
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Menu
▾
▴
Logged In: YES
user_id=1287991
Alan,
If you are talking about Oracle, it is already there. Just
install the Oracle plugin and next time you execute a
query, click on the "Explain Plan" tab before executing. It
should prompt you to create a "PLAN_TABLE" in your Oracle
schema if one does not already exist.
Rob
Logged In: NO
How about Sybase?
I ran the following set command for sybase,
SET SHOWPLAN, noexec ON
go
but did not get the query plan. Is there any sybase plugin?
Thank you very much.
Alan
Logged In: YES
user_id=1287991
Alas, there is no plugin for Sybase as of yet. Or Postgres,
HSQLDB, H2, and the list goes on. Beyond that, someone who
knows the explain plan mechanism in Sybase - or who has time
to research it - is needed to provide input to someone who
has the knowledge to write the plugin - those two people
_could_ be the same person. However, neither Gerd
nor I have access to a Sybase instance to develop it.
I've downloaded the developer edition of ASE 15, but
I haven't had time to set it up. We'll leave this
feature request open then, since the original intent
was for Explain plan in Sybase.
Rob