SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-176
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-61.
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'}