SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-23
CONTROL QUERY Directive
CONTROL QUERY Directive
In NonStop SQL/MP, the CONTROL QUERY compiler directive controls plans for
queries. Options specify whether to resolve names at execution time or startup time,
whether to include hash join algorithms considered for executing queries, and whether
to optimize query response time for returning a few rows or all rows. In NonStop
SQL/MX, the CONTROL QUERY directive has been changed to CONTROL QUERY
DEFAULT. Many options have been changed.
The next table lists the SQL/MP CONTROL QUERY directives. More information about
default settings is provided in the SQL/MX Reference Manual and the SQL/MX Query
Guide.
SQL/MP CONTROL QUERY
Directive
How NonStop SQL/MX
Affects the Same
Functionality Comments
BIND NAMES Internally handled in the
compiler. No external
control.
HASH JOIN CONTROL QUERY SHAPE
to force
See Forcing Query
Execution Plans on
page 5-8.
INTERACTIVE ACCESS ON Not implemented.
MDAM CONTROL TABLE or
CONTROL QUERY SHAPE
to force off
ON by default; see Forcing
Query Execution Plans on
page 5-8.