SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-21
Using the CHECK Option
SQLCOMP Options Behavior
CHECK INOPERABLE PLANS Option
RECOMPILE RECOMPILEALL The SQL executor performs the
similarity check as follows:
•
If the similarity check passes, the
SQL executor executes the
statement using its existing plan
from the program file.
•
If the similarity check fails, the SQL
executor recompiles (in memory)
the statement at SQL load time.
RECOMPILEONDEMAND The SQL executor performs the
similarity check for the statement the
first time it is executed as follows:
•
If the similarity check passes, the
SQL executor executes the
statement using existing plans from
the program file.
•
If the similarity check fails, the SQL
executor recompiles (in memory)
the statement using Guardian
names and DEFINE names as
follows:
Uses names at SQL load time if
execution-time name resolution is
not enabled
Uses names at statement
execution time if execution-time
name resolution is enabled
NORECOMPILE RECOMPILEALL or
RECOMPILEONDEMAND
The SQL executor performs the
similarity check for the statement as
follows:
•
If the similarity check passes, the
SQL executor executes the
statement using plans from the
program file.
•
If the similarity check fails, the SQL
executor returns an error to the
program because of the
NORECOMPILE option.
Table 10-1. Behavior of the SQL Executor for an Invalid Statement or a Changed
DEFINE Detected at SQL Load Time (page 2 of 2)