SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-56
Similarity Checks and Automatic Recompilation of
Embedded SQL/MX Applications
Table 4-15. Comparison of Similarity Checks Between NonStop SQL/MP and
NonStop SQL/MX (page1of2)
Difference Between Compile Time and Run Time
Similarity check
passes in
NonStop
SQL/MP?
Similarity check
passes in
NonStop
SQL/MX?
Name of table Yes Yes
Data in table Yes Yes
Number of partitions Yes for serial
plans
No for parallel
plans
No, unless plan
chooses OLT
optimization
Partition key ranges Yes for serial
plans
No for parallel
plans
Yes
Nonpartitioned table at compile time, partitioned at
run time
Yes No, unless plan
uses OLT
optimization
ESP parallelism used in the plan No No
Number of indexes—more indexes at run time than
at compile time
Yes Yes for SELECT
No for INSERT,
UPDATE,
DELETE
Number of indexes—fewer indexes at run time than
at compile time
Yes if index is
not used by plan
Yes for SELECT
if index not used
by plan
No for INSERT,
UPDATE,
DELETE
Unique index present both at compile time and at run
time
Yes No
Key tags (or values) for indexes Yes No for SQL/MP
indexes
N.A. for SQL/MX
indexes
Creation and redefinition timestamp Yes Yes
Audit attribute Yes with minor
exception
No for SQL/MP
tables
N.A. for SQL/MX
tables