User Guide

SAP AG November 2002
Number of join tables in a SELECT statement 64
Number of triggers per Basis table 3
Number of indexes per table 255
Number of referential CONSTRAINT definitions
(foreign key dependencies) per table
unlimited
Number of references per table unlimited
Number of rows per table limited by database size
Internal length of a table row 8088 bytes
Total of internal lengths of all key columns 1024 bytes
Total of internal lengths of all columns belonging
to an index
1024 bytes
Internal length of a LONG column 2 GB
Length of the columns in an ORDER or GROUP
clause
1020 bytes
unlimited
Nested subqueries 127
Number of join conditions in a WHERE clause of a
SELECT statement
128
Number of correlated columns in an SQL
statement
64
Number of correlated columns in an SQL
statement
16
Number of parameters in an SQL statement 2000
Nested trigger levels
Improvements in SAP DB Version 7.4
System volume dropped
• Converter pages are spread over all data volumes
• No need to configure system volume size
• No need to extend system volume to add data volumes
Converter cache dropped
• The converter and data pages are held in a common cache
• Single configuration parameter for the size of this cache
Database size reduced
• High water mark for database fill rate is independent of the database size
• Number of data volumes at restart time can be smaller than at backup time
User Manual: SAP DB 122