| Description |
Maximum Value |
| Database size |
32 TB (with 8 KB page size) |
| Number of files/devspaces per database |
256 |
| File/devspace size (data) |
128 GB (depending on operating system limitations) |
| File/devspace size (log) |
16 TB (depending on operating system limitations) |
| SQL statement length |
>= 16 KB (Default value 64 KB, defined by a system variable) |
| SQL character string length |
Defined 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 results table |
1023 |
| Number of join tables in a SELECT statement |
64 |
| Number of triggers per Basis table |
3 |
| Number of UNIQUE indexes per table |
510 |
| Number of indexes per table |
510 |
| Number of named 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 |
