SAP Knowledge Base Article - Preview

2112252 - Two different query plans generated due to Statement Cache being used or not- SAP ASE

Symptom

  • The query plan generated by the ASE server for an ad-hoc query could be different depending on:
    •   Statement Cache is enabled (the 'statement cache size' configuration parameter is greater than 0)
    •   Statement Cache is disabled (the 'statement cache size'  configuration parameter is equal to 0)
       
  • The output of the query plan is activated by using "set showplan on".

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

execution, optimization, sproc, optimize,  timeout, limit, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.