Font size:

Database Manager limitations

Table 32. Database manager limitations

Value	Limit
The following table contains limitations on various Database Manager values in Derby.
Most columns in a table	1,012
Most columns in a view	5,000
Maximum number of parameters in a stored procedure	90
Most indexes on a table	32,767 or storage capacity
Most tables referenced in an SQL statement or a view	storage capacity
Most elements in a select list	1,012
Most predicates in a WHERE or HAVING clause	storage capacity
Maximum number of columns in a GROUP BY clause	32,677
Maximum number of columns in an ORDER BY clause	1,012
Maximum number of prepared statements	storage capacity
Most declared cursors in a program	storage capacity
Maximum number of cursors opened at one time	storage capacity
Maximum number of constraints on a table	storage capacity
Maximum level of subquery nesting	storage capacity
Maximum number of subqueries in a single statement	storage capacity
Maximum number of rows changed in a unit of work	storage capacity
Most constants in a statement	storage capacity
Maximum depth of cascaded triggers	16