Symptom
- A query referencing temporary table and having variable is slow on ASE 16.0 SP03 PL10, ASE SP03 PL11, and ASE SP04 PL01 due to suboptimal query plan. The query is fast on previous release before upgrade.
- Configurable parameter 'statement cache size'>0, but the query is not saved to statement cache.
- New configurable parameter ‘temp table statement caching’ = default (1).
Read more...
Environment
- SAP Adaptive Server Enterprise 16.0 SP03 PL10
- SAP Adaptive Server Enterprise 16.0 SP03 PL11
- SAP Adaptive Server Enterpsise 16.0 SP04 PL01
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR#825934, 825934, CR 825934, temp table statement caching , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.