apache > db
Apache DB Project
 
Font size:      

Database Manager limitations

Database Manager limitations


Table 32. Database manager limitations

The following table contains limitations on various Database Manager values in Derby.
ValueLimit
Most columns in a table1,012
Most columns in a view5,000
Maximum number of parameters in a stored procedure90
Most indexes on a table32,767 or storage capacity
Most tables referenced in an SQL statement or a viewstorage capacity
Most elements in a select list1,012
Most predicates in a WHERE or HAVING clausestorage capacity
Maximum number of columns in a GROUP BY clause32,677
Maximum number of columns in an ORDER BY clause1,012
Maximum number of prepared statementsstorage capacity
Most declared cursors in a programstorage capacity
Maximum number of cursors opened at one timestorage capacity
Maximum number of constraints on a tablestorage capacity
Maximum level of subquery nestingstorage capacity
Maximum number of subqueries in a single statementstorage capacity
Maximum number of rows changed in a unit of workstorage capacity
Most constants in a statementstorage capacity
Maximum depth of cascaded triggers16

Previous Page
Next Page
Table of Contents
Index