Database Manager limitations
|
Database Manager limitations
Table 32. Database manager limitations
The following table contains limitations on various Database Manager values in Derby. |
Value | Limit |
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 |
Previous Page
Next Page
Table of Contents
Index