Performance implications for limits

The limits set for Adaptive server mean that the server may have to handle large volumes of data for a single query, DML operation, or command. For example, if you use a data-only-locked table with a char(2000) column, Adaptive Server must allocate memory to perform column copying while scanning the table. Increased memory requests during the life of a query or command mean a potential reduction in throughput.