SAP Knowledge Base Article - Preview

2364881 - Forceplan causes min/max optimization to use Inefficient internal query plan - SAP ASE


When "set forceplan on" is enabled, the internally generated abstract plan may lead to very inefficient plan to satisfy the forceplan for the queries which involved min/max operations.

We will see the tablescan is being used even if the required indices are available for the query.



  • SAP Adaptive Server Enterprise 15.7.x
  • SAP Adaptive Server Enterprise 16.x


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


forceplan, force, CR#801789, 801789, "bad plan", min/max, performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.