Symptom
- A query referencing temporary table and having variables is slow on:
- ASE 16.0 SP03 PL10
- ASE SP03 PL11
- ASE SP04 PL01
- Due to suboptimal query plan.
- The query is fast on previous releases.
- Statement Cache is configured, but the query is not saved to statement cache.
sp_configure "statement cache size", 1111 (a number greater than zero). - New configurable parameter 'temp table statement caching' is set to default (1).
- Previously, trace flag -467 was in use.
Read more...
Environment
- SAP Adaptive Server Enterprise 16.0 SP03
- SAP Adaptive Server Enterprise 16.0 SP04
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR#825934, 825934, CR 825934, temp table statement caching KBA 3135903 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.