SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-144
Considerations for EXPLAIN
be double-quoted if it contains blanks, lower case letters, or special characters;
normally they are not required. It must start with a letter.
module-name
is the name of a file where a static compile stores the information. It is specified
within single quotes.
stmt-name
is the statement pattern that includes name or %, or S%, and so on with single
quotes.
The syntax for the EXPLAIN statement supports four output options. Table 2-1
summarizes the options.
For more information about the operators in the query execution plan, see the SQL/MX
Query Guide.
Considerations for EXPLAIN
Case Considerations
In most cases, words in the commands can be in uppercase or lowercase. The letter
following the OPTIONS keyword must be within single quotes and in lowercase.
Number Considerations
Costs are given in a generic unit of effort. They show relative costs of an operation.
Table 2-1. EXPLAIN Statement Options
Syntax Option Type Purpose
OPTIONS 'f' Formatted Provides the basic information contained in the query
execution plan. This information is formatted for
readability and limited to 79 characters (one line) per
operator.
OPTIONS 'n' Normal user Provides the most important information contained in
the query execution plan. This information is formatted
for readability and is the default output format.
OPTIONS 'e' Expert user Provides all the information contained in the query
execution plan. This information is formatted for user
readability.
OPTIONS 'm' Machine
readable
Provides all the information contained in the query
execution plan. This information is formatted for
machine readability (easy to parse with software
tools).