SAND CDBMS SQL Reference Guide
SAND CDBMS System Limits

SAND CDBMS Limits

Limit Type	Limit	Notes
Maximum number of SAND files (per database)	UNIX: 4096 Windows: 2048	This limit includes primary and secondary database files (*.nxx), but does not include Update Files (*.uxx and *.cxx). However, note that all files held open by SAND CDBMS on UNIX systems are constrained by the ulimit setting for the maximum number of file descriptors for the current execution environment. If the default ulimit value is too low, a user with root privileges should increase it before starting a database.
Maximum number of sessions per client	10
Maximum number of simultaneous connections to a server	512
Maximum width of character columns (bytes)	4056
Maximum number of decimal digits of precision in numerical data type column	50
Maximum length of schema, table, column, view, domain, or user authorization name/password (characters)	128
Maximum number of rows in a table	263-3 (9.2 quintillion)
Maximum number of columns in a table	4096
Maximum number of columns in a PRIMARY KEY or UNIQUE table constraint	64
Maximum number of table references permitted in a single query	128	Includes the tables referenced in the definitions of all views in the query, as well as each subquery, joined table expression, and nested table expression. Note: This limit also includes the internal "meta-tables" produced by SAND CDBMS during the processing of outer joins. Normally, one meta-table is generated per outer join.
Maximum number of column references permitted in a single query	8192	Includes the columns referenced in subqueries and in the definitions of all views in the query
Maximum number of rows in an intermediate results table	500,000,000,000 (500 billion)
Maximum number of values in a domain	263-3 (9.2 quintillion)
Maximum number of rows that can be loaded by ndlm in a single session	231 (2,147,483,648)
Maximum number of records per SCT File	231 (2,147,483,648)