The following limits have changed:
Database size: The maximum database size is approximately the number of files times the file size on a particular platform, depending on the maximum disk configuration. Refer to your operating system documentation for kernel parameters that affect the maximum number of files.
Maximum number of tables per database is now 4,293,918,719
Maximum number of tables or views per query increased to 512.
Maximum length of a SQL statement defaults to Catalog page size (not IQ page size) of connected database. This affects long commands such as RESTORE statements with many renamed databases. To run such commands, you can start the server with an increased -gp setting, although the default of -gp 4096 should generally be used.
Number of rows per table: 248
Field size:
255 bytes for BINARY, VARBINARY
32,767 for CHAR, VARCHAR
Up to 512TB for 128KB pages or 1PB for 512KB pages for LONG BINARY, LONG VARCHAR
For a complete list of limits, see Chapter 8, “Physical Limitations” in the Sybase IQ Reference Manual.
