The following table describes the SQL maximums on such items as the number of database columns,
names, and connections.
Table 1. Netezza Performance Server SQL maximums
| Parameter |
Description |
| Columns |
Maximum per table or view: 1600. Maximum per distribution: 4 |
| Names |
Maximum length of database and column names: 128 bytes |
| Characters |
Maximum number of characters in a char/varchar field: 64,000 |
| Connections |
Maximum connections to the server: 2000. For 11.2.1.8 and earlier, the default is 500. For
11.2.1.9 and later, the default is 1000. |
| Row size |
Maximum row size: 65,535 bytes. Limit also applies to the result set of a query. Within each
row, there is a small amount of overhead for special columns and other factors such as
padding. |