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.

Close

#208 View Query Plan

open
Rob Manning
General (118)
5
2012-12-29
2006-10-04
Anonymous
No

When executing a query, it would be nice to be able to
view the query plan inside SQuirrel SQL Client.
Thanks.

Alan

Discussion

  • Rob Manning
    Rob Manning
    2006-10-05

    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

     
  • Rob Manning
    Rob Manning
    2006-10-05

    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