Maximum Value

Size of data area

32 TB (with 8 KB page size)

Number of data volumes per database

Default value: 256
You can use the database parameter DEVNO_BIT_COUNT to set a value between 64 and 4096 when you install the database system

Size of a data volume

Default value: 128 GB
Depends on the number of data volumes

Size of the log area.

32 TB

SQL statement length

>= 16 KB (Default value 64 KB, defined by a database parameter)

SQL character string length

Defined by a database parameter

Identifier length

32 characters

Numeric precision

38 places

Number of tables

unlimited

Number of columns per table (with KEY)

1024

Number of columns per table (without KEY)

1023

Number of primary key columns per table

512

Number of columns in an index

16

Number of foreign key columns per table

16

Number of the columns in an ORDER or GROUP clause

128

Number of columns in a SELECT statement

1023

Number of columns in an INSERT statement

1024

Number of columns in a results table

1023

Number of join tables in a SELECT statement

64

Number of triggers per Basis table

3

Number of indexes per table

255

Number of referential CONSTRAINT definitions (foreign key dependencies) per table

unlimited

Number of references per table

unlimited

Number of rows per table

limited by database size

Internal length of a table row

8088 bytes

Total of internal lengths of all key columns

1024 bytes

Total of internal lengths of all columns belonging to an index

1024 bytes

Internal length of a LONG column

2 GB

Length of the columns in an ORDER or GROUP clause

1020 bytes

Nested trigger levels

unlimited

Nested subqueries

127

Number of join conditions in a WHERE clause of a SELECT statement

128

Number of correlated columns in an SQL statement

64

Number of correlated columns in an SQL statement

16

Number of parameters in an SQL statement

2000