Maximum Capacity Specifications

<< Click to Display Table of Contents >>

Navigation:  Appendix >

Maximum Capacity Specifications

Previous pageReturn to chapter overviewNext page

 

Object

Maximum sizes / numbers

 

 

Multi-User Edition

Single-User Edition

Bytes per string field

64,000 (also limited by page size)

64,000 (also limited by page size)

Bytes per BLOB field

2GB

2GB

Bytes per index

64,000 (also limited by page size)

64,000 (also limited by page size)

Bytes per row

65,400 (also limited by page size)

65,400 (also limited by page size)

Columns per index

10,000

10,000

Columns per table

65,000

65,000

UNIQUE indexes or constraints per table

30,000

30,000

Database size

32 TB (also limited by file system and OS)

32 TB (also limited by file system and OS)

Identifier length (in characters)

255

255

Locks per connection

2,147,483,647

N/A

Rows per table

2,147,483,647

2,147,483,647

Tables per database

2,147,483,647

2,147,483,647

Bytes per page

65,536

65,536

Pages per database file

2,147,483,647

2,147,483,647

Connections per database

Maximum value of configured connections before creating database file (up to 2,147,483,647)

1

Records in transaction

2,147,483,647 (also limited by available RAM)

2,147,483,647 (also limited by available RAM)

In-memory table size

2,147,483,647 (also limited by available RAM)

2,147,483,647 (also limited by available RAM)

__________________________
Absolute SQL Reference - 25 May 2022, Niels Knabe