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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-62
Examples of SHOWCONTROL
MATCH FULL specifies that attribute-name must be the same as the
attribute name used in a CONTROL QUERY DEFAULT statement. MATCH
PARTIAL specifies that attribute-name must be included in the attribute
name used in a CONTROL QUERY DEFAULT statement. The default is
MATCH PARTIAL.
If attribute-name is a reserved word, such as MAX, MIN, or TIME, you
must capitalize attribute-name and delimit it within double quotes ("). The
only exceptions to this rule are the reserved words CATALOG and SCHEMA,
which you can either capitalize and delimit within double quotes or specify
without quotation marks.
ALL
displays all CONTROL QUERY SHAPE settings, CONTROL TABLE settings,
CONTROL QUERY DEFAULT settings, and a list of all default settings in effect.
See System Defaults Table on page 10-29.
Examples of SHOWCONTROL
•
Show the access plan in effect when CONTROL QUERY SHAPE has not been
executed in the current session:
SHOWCONTROL SHAPE;
No CONTROL QUERY SHAPE settings are in effect.
--- SQL operation complete.
•
Issue one or more CONTROL QUERY SHAPE statements followed by a
SHOWCONTROL SHAPE:
CONTROL QUERY SHAPE NESTED_JOIN(PARTITION_ACCESS(SCAN('J',
FORWARD, MDAM OFF)),MATERIALIZE(PARTITION_ACCESS(SCAN('E',
FORWARD, MDAM OFF))));
--- SQL operation complete.
CONTROL QUERY SHAPE NESTED_JOIN (PARTITION_ACCESS(SCAN),
PARTITION_ACCESS(SCAN('DEPT')));
--- SQL operation complete.
SHOWCONTROL SHAPE;
CONTROL QUERY SHAPE NESTED_JOIN (PARTITION_ACCESS(SCAN),
PARTITION_ACCESS(SCAN('DEPT')));
--- SQL operation complete.