O'Reilly logo

The Official New Features Guide to Sybase ASE 15 by Carrie King Taylor, Steve Bradley, Naresh Adurty, Brian Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10Graphical Plan Viewer

Graphical Plan Viewer from Interactive SQL

The Graphical Plan Viewer (GPV) presents a graphical view of the query plan of the current SQL text. The graphical view makes it easier to understand the performance and the statistics. GPV appears as a tab on the Interactive SQL window. Interactive SQL can be started either from Sybase Central or from a command line. Please refer to the Sybase manuals for the details on Interactive SQL.

The following illustrations of the GPV are based on the Unix version of Interactive SQL.

Make sure that $DISPLAY, $SYBASE, and $SYBROOT are set correctly before starting dbisql. To start the dbisql client on Unix:

cd $SYBASE/DBISQL/bindbisql &

When the dbisql is called from Unix, it opens ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required