The following table describes the
IBM® Netezza® SQL maximums on such items as the number of database columns, names,
and connections.
Table 1. Netezza 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. Default: 500 |
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. |