Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Maximum sizes for base tables

Maximum size of an unpartitioned base table

4 TB

Maximum size of a partition

4 TB

Maximum size of a partitioned base table

64 TB

Number of partitions in a table

16

Number of records in a partition of a partitioned table

268,435,454

Number of records in a partitioned table

4,294,967,264

Number of records in a non-partitioned table

4,294,967,294

Number of columns in a table with data type not equal to
(N)VARCHAR

26,134

Number of columns in a table with data type (N)VARCHAR

1,000

Maximum dimension of a multiple column

255

Number of tables or partitions per space

30,000

Number of indexes per space

32,767

Table 78: Maximum sizes for base tables