Reduce Query Processing Latency

The query processing layer in Adaptive Server 15.7 enables multiple client connections to reuse or share dynamic SQL lightweight procedures (LWPs).

Adaptive Server uses the statement cache to store dynamic SQL statements converted to LWPs. Because the statement cache is shared among all connections, dynamic SQL statements can be reused across connections. These statements are not cached:

select into statements.
insert-values statements with all literal values and no parameters.
Queries that do not reference any tables
Individual prepared statements that contain multiple SQL statements. For example
```
statement.prepare(‘insert t1 values (1) insert 
t2 values (3)’);
```
Statements that cause instead-of triggers to fire

Use the streamlined dynamic SQL or enable functionality group configuration parameters to enable this feature.

See "Memory Use and Performance" in the Performance and Tuning Series: Basics and "Setting Configuration Parameters" in the System Administration Guide, Volume 1.