The referential integrity relaxed limit feature increases the maximum number of table references allowed in a query from 16 to 192. The new limit eliminates the need to write special triggers to compensate for the previous 16-table reference limitation.
When a table has references to other tables, Adaptive Server scans the referenced tables when the table is being modified. Adaptive Server uses scan descriptors to manage the table scans. A scan descriptor is an internal data structure that manages the scan of the tables being queried. To make efficient use of Adaptive Server resources, you can configure Adaptive Server to use an appropriate number of scan descriptors for your system.
For more information on using referential integrity, see the Transact-SQL User’s Guide.
For information on configuring scan descriptors, see the number of aux scan descriptors configuration parameter in Chapter 11, “Setting Configuration Parameters,” of the System Administration Guide.
