Use this pane to view the attributes of nodes that are displayed
in a diagram of an access plan.
To view the description of a node, select the node in the Canvas
and then open the Description of Selected Node pane by clicking its title.
The pane looks like this:
Figure 1. Description of Selected Node pane
If you right-click a node in the Canvas and
select Show Description, Visual Explain opens a window
that is identical to the Description of Selected Node pane.
You can open multiple instances of this window if you want to compare the
attributes of different nodes.
The different sections of the Description
of Selected Node pane are as follow:
- The first section displays the type and name of the node. If the node
is related to other data server objects, you can expand the node to see those
objects.
- The second section contains the following buttons:
Table 1. Actions
that you can take by clicking these buttonsButton |
Action |
|
Save the description of the selected node |
|
Print the description of the selected node |
|
Sort the attributes of the selected node |
|
Filter the attributes of the selected nodeDepending
on the node that you select, you can filter the attributes on the following
criteria: - Cost estimation
- The attributes that appear help you to estimate the cost of the query
in units that are specific to the type of data server that you are using.
- Space
- The attributes that appear help you to estimate the amount of storage
that the query requires to run.
Select All to turn off filtering.
|
- The third section lists the attributes of the node and the data server
objects that are related to the node.
- The fourth section displays a short description of the selected attribute
or related data server object. You can toggle this section by clicking the
button.