| Description |
Maximum Value |
| Database size |
32 TB (with 8 KB page size) |
| Number of files/volumes per database |
64...4096, specified by a configuration parameter |
| File/volume size (data) |
518 ...8 GB (dependent on operating system limitations) |
| File/volume size (log) |
16 TB (dependent on operating system limitations) |
| SQL statement length |
>= 16 KB (Default value 64 KB, specified by a system variable) |
| SQL character string length |
Specified by a system variable |
| 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 columns in an ORDER or a GROUP clause |
128 |
| Number of columns in a SELECT statement |
1023 |
| Number of columns in an INSERT statement |
1024 |
| Number of columns in a result 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 referring 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 primary key columns |
1024 Bytes |
| Total of internal lengths of all foreign 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 columns in an ORDER or a 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 tables in an SQL statement |
16 |
| Number of parameters in an SQL statement |
2000 |
