SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-8
Limits
A numeric literal cannot exceed 18 digits.

Default value for a character column
The maximum length for the default value is 8 characters.

First key length
A specification for the first key for partitions cannot exceed the length of the
user-defined primary key or clustering key for tables or the length of the index key
for indexes. See the Index length item later in this subsection.

FROM clause tables
The maximum number of tables that can be specified in a FROM clause is 16. This
maximum includes the underlying base tables of views.

IN predicate expressions
The maximum number of expressions in the expression-list of an IN
predicate is 500.

Index length
The maximum length depends on the index type:
The length of any column that allows null values is 2 bytes longer than the
declared length of the column.

Indexes per table
The maximum number of indexes depends on the number of columns in the key,
the number of partitions in each index, and additional factors. If there are no
partitions in the indexes, a table can have a maximum of from 60 to 120 indexes; in
some situations, however, as few as 32 indexes are allowed. If there are 25
partitions per index and there is a total of 10 columns in the primary key and index,
the maximum number of indexes in a table could be reduced to as few as 34 (for a
table with standard partition arrays) or 66 (for a key-sequenced table with extended
partition arrays).
Additional factors that affect the index limit are the number of columns in the index,
the number of indexes for the underlying table, the number of protection views
defined for the underlying table, and the number of catalogs used to describe the
indexes. The description of all the indexes for a table must fit in a file label.

Lock limit
Unique The sum of the length of the columns in the index cannot exceed
253 bytes.
Nonunique The sum of the length of the columns in the index plus the sum of
the key of the underlying table cannot exceed 253 bytes.