Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
When executing a query, it would be nice to be able to
view the query plan inside SQuirrel SQL Client.
Logged In: YES
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.
Logged In: NO
How about Sybase?
I ran the following set command for sybase,
SET SHOWPLAN, noexec ON
but did not get the query plan. Is there any sybase plugin?
Thank you very much.
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.