Distributed query processing and micro
query performance has improved in SAP Sybase IQ
16.0. The new Cache Ejection feature improves performance
by eliminating unnecessary cache page reads.
Cache Ejection
This enhancement prevents the buffer manager from performing unnecessary rereads of cached pages from disk, improving performance through a reduction of disk I/O and internode communication.
Micro Query Performance Improvement
In previous releases, the QUERY_PLAN option was ON by default, meaning that every query generated a query plan regardless of the size of the query. In SAP Sybase IQ 16.0, use the new QUERY_PLAN_MIN_TIME option when QUERY_PLAN is ON to prevent the server from generating query plans for micro queries, resulting in a database server performance improvement.
Created May 23, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com