Neoview Workload Management Services Guide (R2.4)
227993 384 318 582 6 27981 1876.0
1876.0 8 89344 212110188706360365
--- WMS operation complete.
NS%
For the syntax, see the “STATUS QUERY Command” (page 136).
Each of the commands mentioned above displays the same columns of data in its output. For
more information, see Table A-13 (page 132).
NOTE: By default, WMS collects runtime statistics for all executing queries at an interval of
five seconds. For information on how to change the default, see “ALTER WMS Command”
(page 106).
Displaying the Explain Plan of a Query
Use the STATUS QUERY query-id PLAN command to display the execution plan of a specific
query. For the STATUS QUERY query-id PLAN command to succeed, the output option,
PLAN, must be enabled for the service. If the default NO_PLAN is specified for the service, the
STATUS QUERY query-id PLAN command does not return a query execution plan.
This STATUS QUERY query-id PLAN command displays the query execution plan for a
specified query ID:
SQL>mode ns
NS%status query MXID01002020782212110119447606071000000015509ROLE.USR200_498_S1 plan;
QUERY_PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
16 . 17 root 4.83E+010
15 . 16 esp_exchan
ge 1:4(hash2) 4.83E+010
14 3 15 hybrid_hash_join 4.83E+010
13 6 14 hybrid_hash_join 1.03E+008
12 9 13 hybrid_hash_join 2.19E+005
11 . 12 esp_exchange 4(hash2):1
(m) 4.69E+002
10 . 11 partition_access 4.69E+002
. . 10 file_scan fs fr COLS 4.69E+002
8 . 9 esp_exchange 4(rep-b):1 (m) 4.69E+002
7 . 8 partition_access 4.69E
+002
. . 7 file_scan fs fr COLS 4.69E+002
5 . 6 esp_exchange 4(rep-b):1 (m) 4.69E+002
4 . 5 partition_access 4.69E+002
. . 4 file_scan fs fr COLS 4.69E+002
2 .
3 esp_exchange 4(rep-b):1 (m) 4.69E+002
1 . 2 partition_access 4.69E+002
. . 1 file_scan fs fr COLS 4.69E+002
--- WMS operation complete.
NS%
For the syntax, see the “STATUS QUERY Command” (page 136).
To interpret explain plans, see the Neoview Query Guide and the Neoview Query Support Guide.
Displaying the SQL Text of a Query
Use the STATUS QUERY query-id TEXT command to display the SQL text of a specific query.
For the STATUS QUERY query-id TEXT command to succeed, the output option, TEXT, must
be enabled for the service. If the default NO_TEXT is specified for the service, the STATUS
QUERY query-id TEXT command does not return SQL text for the query.
This STATUS QUERY query-id TEXT command displays the SQL text for a specified query
ID:
74 Managing Workload