SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Creating an SQL/MX Database
HP NonStop SQL/MX Installation and Management Guide—544536-007
7-43
Database Design Guidelines for Improving OLTP
Performance
°
Use datetime fields if datetime arithmetic is needed in an SQL query (for
example, where date-col + interval '1' day > date '2001-09-
11').
°
Use LARGEINT or CHAR if datetime is needed for storage and retrieval only.
•
Where possible, avoid adding columns to a table:
°
Added columns turn off internal expression optimizations.
°
If you add a column, reload the table.