SQL/MX 3.x Query Guide (H06.22+, J06.11+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

141

142

143

144

145

146

147

148

149

150

SQL/MX Operators

HP NonStop SQL/MX Query Guide—640323-001

7-13

EXPLAIN Operator

DESCRIPTION

fragment_id ........... 13

parent_frag ............ 0

fragment_type .......... esp

buffer_size ............ 6,250

record_length ......... 40

parent_processes ....... 1

child_processes ........ 2

child_partitioning_func hash partitioned 2 ways on

(([0]ValueIdUnion(\DMR11.$DATA04.ZSDWC1HX.ZVB7V200

.A, \DMR11.$DATA04.ZSDWC1HX.ZVB7V200.A,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.A,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.A),

[0]ValueIdUnion(\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.B

, \DMR11.$DATA04.ZSDWC1HX.ZVB7V200.B,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.B,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.B),

[0]ValueIdUnion(\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.C

, \DMR11.$DATA04.ZSDWC1HX.ZVB7V200.C,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.C,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.C),

[0]ValueIdUnion(\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.D

, \DMR11.$DATA04.ZSDWC1HX.ZVB7V200.D,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.D,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.D),

[0]ValueIdUnion(\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.E

, \DMR11.$DATA04.ZSDWC1HX.ZVB7V200.E,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.E,

\DMR11.$DATA04.ZSDWC1HX.ZVB7V200.E)))

bottom_partition_input_ \:_sys_HostVarLoHashPart,

\:_sys_HostVarHiHashPart

EXPLAIN Operator

Stored Function Group

The EXPLAIN operator executes a stored function. The operator for an EXPLAIN

operator is always EXPLAIN.