SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-96
Examples of SHOWSHAPE
•
Display the access plan for the given statement:
SET NAMETYPE NSK;
SET MPLOC $DATA06.PERSNL;
SHOWSHAPE
SELECT first_name, last_name, deptnum, salary
FROM persnl.employee
WHERE salary >
(SELECT MAX (salary)
FROM persnl.employee
WHERE deptnum = 1500);
control query shape
hybrid_hash_join(partition_access(
sort_groupby(scan(path 'EMPLOYEE',
forward, mdam off))),
partition_access(scan(path 'EMPLOYEE',
forward, mdam off)));
--- SQL operation complete.
•
This example shows the output of the SHOWSHAPE command using the
MultiUnion operator:
>>showshape select * from t1 union all select * from t1 union
all select * from t1;
control query shape
expr(MultiUnion(partition_access(scan(path 'CAT.SCH.T1',
forward, blocks_per_access 1 , mdam off)),
partition_access(scan(path 'CAT.SCH.T1', forward,
blocks_per_access 1, mdam off)),partition_access(scan(path
'CAT.SCH.T1', forward, blocks_per_access 1 , mdam off))));
--- SQL operation complete.