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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Administering your database » SQL Anywhere graphical administration tools » Using Interactive SQL

 

Using the Plan Viewer to view graphical plans

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

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

  2. Choose 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.
 ♦  To open a graphical plan
  1. Choose Tools » Plan Viewer.

  2. Click Open.

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

 See also

Configuring the graphical plan