SAP Knowledge Base Article - Preview

2922900 - Enhanced showplan output for prepared statements -SAP ASE

Symptom

  • Showplan output for dynamic prepared statements has been enhanced.
  • The message, "Executing a newly cached prepared statement (SSQL_ID = <value>)", will be printed for the first execution of a dynamic prepared statement.
  • The message, "Executing a previously cached prepared statement (SSQL_ID = <value>)", will be printed when using a previously cached plan from statement cache.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL09 and higher

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Sybase, ASEServer, SAPASE, dataserver, showplan, prepared statement.   , 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.