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

SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

forceplan, force, CR#801789, 801789, "bad plan", min/max, performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.