SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-17
Using the CHECK Option
These DDL operations do not invalidate a program compiled with the CHECK
INOPERABLE PLANS option if the similarity check is enabled for each referenced
object. The program also retains its entries in the USAGES table. (These operations,
however, do update the redefinition timestamp of each referenced object in the DDL
statement.)
•
ALTER TABLE...ADD PARTITION statement
•
ALTER TABLE...ADD COLUMN statement (for more information, including
restrictions, see Enabling the Similarity Check for Tables and Protection Views on
page 10-26)
•
ALTER TABLE statement to move or split partitions (including a simple move,
one-way split, or two-way split) or change the type of partition array
•
ALTER TABLE...DROP PARTITION statement
•
ALTER INDEX...DROP PARTITION statement (if the similarity check is enabled for
the base table)
•
ALTER INDEX statement to move or split index partitions
•
CREATE INDEX statement
•
UPDATE STATISTICS...RECOMPILE statement
The ALTER TABLE... RENAME, ALTER INDEX... RENAME, and ALTER INDEX...
ADD PARTITION statements do not invalidate a program whether or not it was
compiled with the CHECK INOPERABLE PLANS option.
Note. These DDL operations always invalidate a program, even if the program is compiled with
the CHECK INOPERABLE PLANS option:
•
ADD CONSTRAINT statement
•
DROP CONSTRAINT statement
•
DROP TABLE statement
•
DROP VIEW statement
•
ALTER TABLE or ALTER VIEW statement with the SIMILARITY CHECK clause (for more
information, see Enabling the Similarity Check for Tables and Protection Views on
page 10-26)
•
DROP INDEX statement if the program contains a plan that refers to the dropped index