Viewing plans using the Interactive SQL Plan Viewer

The Plan Viewer is a graphical tool for viewing graphical plans for SQL Anywhere databases and text plans for UltraLite databases.

To start the Plan Viewer
  1. Open Interactive SQL.

  2. Choose Tools » Plan Viewer (or press Shift+F5).

    The Plan Viewer appears in a separate window.

Navigating the Plan Viewer

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

Viewing graphical plans in Interactive SQL
Configuring the graphical plan