The details element
Derby Tools and Utilities Guide
67
For example:
<stmt_id>9ac8804c-0129-cc31-ca9a-00000047f1e8</stmt_id>
· The
details
element:
This element contains the query plan, as a tree structure of plan nodes.
For a particular query there is only one root plan node.
· A
node
element:
Contains the details of a plan node of the query plan. This element can contain zero
or many child elements of the same type (
node
elements).
This element contains one or more attributes, given that they are not null. The
possible attributes and their meanings are shown in the following table.
Table 5.
Attributes of the
node
element
Attribute Name
Meaning
name
Name of the plan node
input_rows
Retrieved from the INPUT_ROWS row of the
SYSXPLAIN_RESULTSETS system table
returned_rows
Retrieved from the RETURNED_ROWS row of the
SYSXPLAIN_RESULTSETS system table
no_opens
Retrieved from the NO_OPENS row of the
SYSXPLAIN_RESULTSETS system table
visited_pages
Retrieved from the NO_VISITED_PAGES row of the
SYSXPLAIN_SCAN_PROPS system table
scan_qualifiers
Retrieved from the SCAN_QUALIFIERS row of the
SYSXPLAIN_SCAN_PROPS system table
next_qualifiers
Retrieved from the NEXT_QUALIFIERS row of the
SYSXPLAIN_SCAN_PROPS system table
scanned_object
Retrieved from the SCAN_OBJECT_NAME row of the
SYSXPLAIN_SCAN_PROPS system table
scan_type
Retrieved from the SCAN_TYPE row of the
SYSXPLAIN_SCAN_PROPS system table
sort_type
Retrieved from the SORT_TYPE row of the
SYSXPLAIN_SORT_PROPS system table
sorter_output
Retrieved from the NO_OUTPUT_ROWS row of the
SYSXPLAIN_SORT_PROPS system table
For example:
<node name="TABLESCAN" returned_rows="100000" no_opens="1"
visited_pages="2165" scan_qualifiers="None" scanned_object="USERS"
scan_type="HEAP" >
PlanExporter example
This example shows the steps that you must follow in order to use the
PlanExporter
tool.
1. Move to the directory where your database was created.
