Sybase DC35823-01-1500-04 manual Adaptive Server specifications, Table specifications

Adaptive Server specifications

Maximum number of users	2146484223
per database
Maximum number of	1032193
groups per database
Table specifications
User objects per database	231 – 255
Indexes per table	250 (one clustered index)
Rows per table	Limited by available	Maximum 232
	storage
Columns per composite	31
index

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 255

name

Query specifications

Maximum number of tables 64

participating in a query, for a query without a union, or for each side of a union in a query

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 256 “union” query

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	Unlimited	Includes database where
participating in one transaction		transaction began, all databases
		changed during transaction, and
		tempdb, if it is used for results or
		worktables

14 Adaptive Server Enterprise