SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-28
Query Type Comparison
Deletes with key equality predicates:
DELETE FROM t1 WHERE KEY=1
YY
Deletes with column comparison predicate:
DELETE FROM t1 WHERE key_col_a=key_col_b
YN
Deletes with any nonkey predicate:
DELETE FROM t1 WHERE nonkey_col_a <> 1
YN
Deletes with subquery:
DELETE FROM t1 WHERE col_a IN
(SELECT col_b FROM t2 WHERE col_c=1)
YN
Selects with key equality predicate:
SELECT * FROM t1 WHERE key_col_a=1
YY
Select with column comparison predicate:
SELECT * FROM t1 WHERE key_col_a=key_col_b
YN
Selects with a nonkey predicate:
SELECT * FROM t1 WHERE nonkey_col<1
YN
Selects with a subquery:
SELECT * FROM t1
WHERE col_a IN (SELECT col_b FROM t2)
YN
Single row two-way joins:
SELECT * FROM t1,t2
WHERE t1.key_col_a=t2.key_col_b
AND t1.key_col_a=1
AND t2.key_col_b=2
YY
Selects with multirow two-way joins:
SELECT * FROM t1,t2
WHERE t1.key_col_a=t2.key_col_b
YN
Selects with multirow, multiway nonequi joins:
SELECT * FROM t1,t2,t3
WHERE t1.key_col_a>t2.key_col_b
AND t2.key_col_b<t3.key_col_c
YN
Aggregates with key equality predicate:
SELECT COUNT(*) FROM t1 WHERE key_col_a=1
YY
Aggregates with column comparison predicate:
SELECT COUNT(*) FROM t1
WHERE key_col_a=key_col_b
YN
Aggregates with nonkey predicate:
SELECT COUNT(*) FROM t1 WHERE nonkey_col<1
YN
Table 3-6. Query Type Comparison (page 2 of 3)
Type of Query
NonStop
SQL/MP
NonStop
SQL/MX