Relaxed Query Limits

SAP ASE version 16.0 increases some column and table restrictions.

Limit Limit in Versions Earlier Than 16.0 Limit in Versions 16.0 and Later
Number of tables in select queries 50 tables, 46 worktables 250 tables, 46 worktables
Number of subqueries in a select query 50 250
Maximum number of columns allowed in an order by clause 31 400