SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-47
Examples of CONTROL QUERY SHAPE
max(ps_partkey) from partsupp);
--- SQL command prepared.
>>display_explain options 'f' xx;
LC RC OP OPERATOR OPT DESCRIPTION
CARD
--- --- --- -------------------- -------- --------------
------ -------
13 . 14 root
1.00E+0
5 12 13 nested_join
1.00E+0
8 11 12 nested_join
1.00E+0
10 . 11 split_top 1:72(logph)
1.00E+0
9 . 10 partition_access
1.00E+0
. . 9 file_scan_unique fr PART (s)
1.00E+0
7 . 8 split_top 1:72(logph)
6.66E+6
6 . 7 partition_access
6.66E+6
. . 6 index_scan fr PX1 (s)
6.66E+6
4 . 5 shortcut_scalar_aggr
1.00E+0
3 . 4 firstn
1.00E+0
2 . 3 split_top 1:72(logph)
8.00E+7
1 . 2 partition_access
8.00E+7
. . 1 index_scan fr PSX2 (s)
8.00E+7
--- SQL operation complete.
>>log;