Adaptive Server specifications
14 Adaptive Server Enterprise
Maximum number of users
per database 2146484223
Maximum number of
groups per database 1032193
Table specifications
User objects per database 231 – 255
Indexes per table 250 (one clustered index)
Rows per table Limited by available
storage Maximum 232
Columns per composite
index 31
Creation of clustered index 1.2*(x + y)
x = total data space in
table,
y = sum of space of all
nonclustered indexes on
table,
and 20 percent overhead
for logging
For sorted data, approximately 20
percent of the table size needed
Maximum size of object
name 255
Query specifications
Maximum number of tables
participating in a query, for a
query without a union, or for
each side of a union in a query
64 Maximum of 50 user tables,
including result tables, tables
referenced by views (the view
itself is not counted) correlations
and self-joins; maximum of 14
worktables
Maximum number of tables in a
“union” query 256 Includes up to 50 user tables and 14
work tables on every side of the
union, for a total of up to 256 tables
across all sides of the union.
Maximum number of databases
participating in one transaction Unlimited Includes database where
transaction began, all databases
changed during transaction, and
tempdb, if it is used for results or
worktables