SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-90
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.