SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-145
EXPLAIN Statement
EXPLAIN Statement
Considerations for EXPLAIN
Examples of EXPLAIN
The EXPLAIN statement generates and displays the result of the EXPLAIN function,
describing an access plan for a SELECT, INSERT, DELETE, UPDATE, or CALL
statement. It displays the query execution plans in a readable format. It can
display plans from modules created by the SQL/MX compiler.
The EXPLAIN statement can also be used from JDBC or ODBC application like any
other SQL/MX Statement.
For a description of the result table of the EXPLAIN function, see EXPLAIN Function
on page 9-55.
You can use the EXPLAIN statement within an MXCI, JDBC, or ODBC session.
f
formatted.
n
normal user (default setting).
e
expert user.
m
machine readable format.
query-text
is a DML statement such as SELECT * FROM T3.
prepared-stmt-name
is an SQL identifier containing the name of a statement already prepared in this
session. An SQL identifier is not case sensitive unless it is double-quoted. It must
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.
EXPLAIN [options {'f' | 'n' | 'e' | 'm'}] {query-text |
prepared-stmt-name | 'stmt-name' from 'module-name'}