SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Limits
HP NonStop SQL/MX Reference Manual—523725-004
C-2
°
There are no restrictions on the number of partitions an table can support, but
beyond 512, performance and memory issues might occur.
°
Partitions can be on the same physical disk as the main file (SQL/MP partitions
must be on a different disk.)
•
PFS usage is decreased in the file system
°
This issue affects the number of opens.
•
Referential constraints
°
A table can have an unlimited number of referential constraints, and you can
specify the same foreign key in more than one referential constraint, but you
must define each referential constraint separately.
•
Tables
°
The maxium length of a row is 4040 bytes, but not all of that is available.
Depending on data types you use, NonStop SQL/MX might use some bytes for
internal use.
°
The clustering key for a table cannot be longer than 255 bytes. If the table has
triggers, the clustering key length cannot be longer than 247 bytes. If the key
length is greater than 247, trigger creation will fail.