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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
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.