SAP Knowledge Base Article - Preview

3037884 - Cached statements with outer joins may show poor performance - SAP ASE

Symptom

  • When executing a query which exists in the statement cache either through a Java prepared statement or standard SQL language request
  • Pperformance can vary between optimal and poor depending on the search arguments supplied.
  • This only happens when the server setting "enable literal autoparam" is zero or a Java application specifically turns it off using the LITERAL_PARAM=FALSE connection property.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Sybase, ASEServer, SAPASE, dataserver, CR822373, CR#822373, bad, slow, dynamic , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.