Neoview SQL Reference Manual (R2.2)

C Limits
This appendix lists limits for various parts of Neoview SQL
128 characters in length.Column names
The maximum combined length of the columns for a
REFERENCE or PRIMARY KEY constraint is 2048 bytes.
Constraints
You might need to increase the number of locks per
volume, or DROP SCHEMA CASCADE can fail.
DROP SCHEMA (check this CASCADE transactions
Neoview SQL generates good plans up to approximately
40 tables. Beyond that, executor performance is affected.
FROM clause of the SELECT statement
At least 5000 expressions are allowed.IN predicate
The maximum combined length of the columns for an
index is 2048 bytes. A nonunique index consists of columns
and a clustering key. A unique index consists of columns
only.There is no restriction on the number of indexes per
table but creating many indexes on a table will affect
performance.
Indexes
150 records can be inserted into a Neoview SQL table in
a single INSERT operation.
INSERT operations
40 tables can be joined, including base tables of views, but
joining more tables affects performance.
Joins
128 characters in length.Schema names
ANSI names are of the form schema.object, where each
part can be up to 128 characters long.The maximum length
of a row is 4040 bytes for a blocksize of 4096 and 32712 for
a blocksize of 32768.The clustering key for a table cannot
be longer than 2048 bytes.
Tables
441