Why the new 50-table limit/query?
The new limit improves your ability to run queries with multiple subqueries because you do not have to break up queries as recommended for pre-12.0 servers. See the Adaptive Server Enterprise Performance and Tuning Guide for more information on optimizing queries when using many tables. However, if you increase the number of tables referenced in a query, you may need to reset the configuration parameter number of aux scan descriptors. See the chapter “Setting Configuration Parameters” in Adaptive Server Enterprise System Administration Guide.
Related Questions
- I need data that shows the conversion between Baylor IDs and rs IDs, but the Batch Query limit is 30,000 SNP IDs, which means I’d have to run 56 batch queries. Is there an easier way?
- Can I limit the number of rows returned by a query using the ICOBOL ODBC driver?
- Is there a limit on the number of keywords for a Solr query?
