SAND CDBMS Limits
Limit Type Limit Notes
Maximum number of SAND files (per database)
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
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
Maximum number of values in a domain
Maximum number of rows that can be loaded by ndlm in a single session 231
Maximum number of records per SCT File 231