SAP ASE extended-limit capabilities vary by type of table and the database logical page size
The column and row limits for allpages-locked (APL) tables are:
|
Maximum APL Table Limits |
Number of Columns |
Column Size 2K Page |
Column Size 4K Page |
Column Size 8K Page |
Column Size 16K Page |
|---|---|---|---|---|---|
|
Fixed-length column |
1024 |
1960 bytes |
4008 bytes |
8104 bytes |
16296 bytes |
|
Variable-length column |
254 |
1948 bytes |
3988 bytes |
8068 bytes |
16228 bytes |
The column and row limits for data-only-locked (DOL) tables are:
|
Maximum DOL Table Limits |
Number of Columns |
Column Size 2K Page |
Column Size 4K Page |
Column Size 8K Page |
Column Size 16K Page |
|---|---|---|---|---|---|
|
Fixed-length column |
1024 |
1958 bytes |
4006 bytes |
8102 bytes |
16294 bytes |
|
Variable-length column |
1024 |
1954 bytes |
4002 bytes |
8098 bytes |
16290 bytes |