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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|