Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

Plan Viewer and graphical plans in Interactive SQL

The Plan Viewer is a graphical tool for viewing graphical plans for SQL Anywhere databases and text plans for UltraLite databases. See Viewing an UltraLite execution plan.

 Create a graphical plan with detailed and node statistics
  1. Open Interactive SQL and connect to the database.

  2. Click Tools » Plan Viewer or press Shift+F5.

    The Plan Viewer appears in a separate window.

  3. Type a statement in the SQL pane.

  4. In the Statistics level list, click Detailed and node statistics.

  5. Click Get Plan to generate a plan for the specified query.

  6. Click Save As.

  7. Specify where you want to save the plan and type a file name. Click Save.

The Plan Viewer window is divided into panes:

  • SQL pane   This pane provides a place for you to type SQL statements that you want to generate plans for.

  • Results pane   This pane shows the graphical plan. This pane is only for SQL Anywhere databases.

  • Details pane   This pane provides text details about the plan for SQL Anywhere databases. For UltraLite databases, this pane shows the text plan.

Plan Viewer user interface.
 Open a graphical plan
  1. Click Tools » Plan Viewer.

  2. Click Open.

  3. Select a plan file (.saplan), and then click Open.

 See also

Graphical plan configuration