Parameter | Limit |
Maximum database size | Unlimited; files can be spread across devices |
Maximum tables in a database | 1.1 billion |
Maximum files per database | N/A |
Maximum files per instance | N/A |
Maximum page size | N/A |
Maximum cache buffers | 140 terabytes (2^47 bytes) |
Maximum rows per table | 140 trillion (2^47) |
Maximum row width per table | 256 KB |
Maximum fields (columns) per table | 2048 |
Maximum fields (columns) per index | 32 |
Maximum locations per database | 1024 |
Maximum locations per table | 32 table locations; 1024 column locations |
Maximum locations per column | 32 |
Maximum integer size | 64 bits (INTEGER8) |
Maximum decimal precision | 38 digits |
Maximum float precision | 64-bit IEEE (FLOAT8) |
Maximum length of a character field | 32,000 bytes |
Maximum length of a varchar field | 32,000 bytes |
Maximum size of an SQL statement | Unlimited |
Maximum members in an IN list | Unlimited |
Maximum logical operators in a WHERE clause | Unlimited |
Maximum join conditions | Unlimited |
Maximum tables in a join | 382 |
Maximum size of Positional Delta Tree (PDT) | 4 billion modified (inserted, updated, deleted) records per table |
Unicode support | UTF-8 and UCS-2 (UTF-16 without surrogate support) |
XML support | Consume and publish |