SQL/MP Query Guide

Improving Query Performance With Environmental
Options
HP NonStop SQL/MP Query Guide—524488-003
4-33
Minimizing Overhead of Query Programs
For information about limits on concurrency, see the SQL/MP Reference Manual. For
information about maximizing concurrency during DDL operations, see the SQL/MP
Installation and Management Guide.
Minimizing Overhead of Query Programs
NonStop SQL/MP supports several features that can help you minimize the overhead
of query programs:
•
For query programs that use static SQL statements, name resolution can occur at
execution time. Thus, if you want a transaction to execute against one of several
different tables, this feature makes it possible to do so without using dynamic SQL,
thus avoiding the compilation overhead of dynamic SQL. To specify execution-time
name resolution, use the CONTROL QUERY BIND NAMES directive.
•
After DDL operations or other activity that might invalidate a query plan, you can
minimize recompilation of statements within a program by using the similarity
check to avoid recompilation if the operation did not affect the query plan of the
specific statement.
•
You can install programs in a new system without recompiling them by using the
REGISTERONLY option.
•
You can install programs in a new system without recompiling or registering them
by using the NOREGISTER option.
For more information about these features, see the SQL/MP Programming Manual for
your host language, the SQL/MP Reference Manual, and the SQL/MP Installation and
Management Guide.