- 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".
SAP Adaptive Server Enterprise (ASE) all versions
execution, optimization, sproc, optimize, timeout, limit, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis 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.