SAP Knowledge Base Article - Preview

3201009 - A query referencing temporary table is slow on ASE 16.0 SP03 PL10, ASE 16.0 SP03 PL11, and ASE 16.0 SP04 PL01 - SAP ASE

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.