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

SQL Anywhere 12.0.1 » Context-Sensitive Help » Interactive SQL help


Plan Viewer window

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. To control whether or not the SQL pane is hidden, click the Hide/Show SQL button.

  • Results pane   This pane shows a graphical diagram of the plan and only appears once you have clicked the Get Plan button. To obtain context-sensitive help for each node in the graphical plan, right-click the node and choose Help. The Results pane is only for SQL Anywhere databases.

  • Details pane   This pane provides text details about the generated plan for SQL Anywhere databases. Clicking alternate nodes in the Results pane determines what text appears in the Details pane.

  • Advanced Details   The information displayed in the Advanced Details pane is dependent on the specific operator. For root nodes, the Advanced Details pane contains the settings that were in effect for the connection options when the query was optimized. For other node types, the Advanced Details pane might contain information about which indexes or materialized views were considered for the processing of the particular node.

You can customize the output in the Results pane using the following options:

  • Statistics level   Specifies the type of query execution statistics the database server monitors when the query is executed.

  • Cursor type   Specifies the type of cursor used in the plan. The type of cursor you choose affects optimizer performance.

  • Update status   Specifies how the optimizer should treat the given cursor.

 See also