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
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 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.