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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Query Optimizer » Query optimization and execution » Reading execution plans » Reading graphical plans

 

Viewing detailed graphical plan node information

To view detailed node information in the graphical plan, in the left pane click the node in the graphical diagram. Details about the node appear on the right in the Details and Advanced Details panes. In the Details pane, statistics for the node appear in three sections:

Node statistics are statistics related to the execution of the specific node. Leaf nodes have a Details pane that displays estimated and actual statistics for the operator. When a leaf node appears on the right side of a parent node, you can fetch rows from the parent operator multiple times. For example, with a nested loop join the leaf node (a sequential, index, or RowID scan node) contains both per-invocation (average) and cumulative actual run-time statistics.

When a node is not a leaf node it consumes intermediate result(s) from other nodes and the Details pane displays the estimated and actual cumulative statistics for this node's entire subtree in the Subtree Statistics section. Optimizer statistic information representing the entire SQL request is present only for root nodes. Optimizer statistics values are related specifically to the optimization of the statement, and include values such as the optimization goal setting, the optimization level setting, the number of plans considered, and so on.

In the example shown below, the nested loops join (JNL) node is selected and the information displayed in the right pane pertains only to that node. For example, the Predicates description is TRUE, indicating that a predicate is not applied. If you click the Customers node, the Predicate value changes to Customers.ID > 100 : 100% Index; true 126/126 100%.

The Details tab in Interactive SQL, showing the graphical plan with statistics for a query.

The information displayed in the Advanced Details pane is dependent on the specific operator. For root nodes, the Advanced Details pane contains the setting of all connection options in effect when the query was optimized. With 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.

To obtain context-sensitive help for each node in the graphical plan, right-click the node and choose Help.

For more information about the abbreviations used in the plan, see Abbreviations in the plan.

Note

If a query is recognized as a simple query, some optimization steps are bypassed and neither the Query Optimizer section nor the Predicate section appear in the graphical plan. For more information about bypassed queries, see How the optimizer works.

See also