The number of user tables and worktables that can be used for a query has been increased from earlier versions of Adaptive Server. In earlier versions, a query and any views used in a query could reference at most 16 user tables, and the maximum number of worktables that could be created was 12. The limits are now 50 user tables and 14 worktables. Limits on the number of referential integrity checks allowed (192) and the number of subqueries allowed in a query (16) have not changed.
You may need to reset the configuration parameter number of aux scan descriptors if you increase the number of tables referenced in queries.
For information on how queries are optimized when large numbers of tables are included, see Chapter 7, “Access Methods and Query Costing for Joins and Subqueries,” in the Performance and Tuning Guide.
For information on resetting scan descriptors, see number of aux scan descriptors in Chapter 17, “Setting Configuration Parameters,” in the System Administration Guide.
