SAP Knowledge Base Article - Preview

2736509 - ASE 16 CIS update queries may not pick the best plan

Symptom

When running a CIS update query, the ASE will check the query for any of the updatable columns being used in table joins and/or search arguments then make decisions about the execution plan accordingly. There is an error in this logic such that join columns and search columns get confused by ASE which can result in an incorrect execution plan or the rejection of a valid abstract plan. This can lead to poor performance. For example, a valid abstract plan might give an error like this:

Abstract Plan (AP) Warning : An error occured while applying the AP:
<your plan here>

The children of the <your join operator> operator don't have the required properties, as ordering, partitioning. The logical relational operation is valid at this point but it can not be implemented by this physical operator.
The AP property enforcer operators 'sort', 'xchg' or 'enforce' can be used to create the needed physical properties.

There may also be a suggested template abstract plan in the error message which also gives the same error.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 (15.7 unaffected)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 16.0 (15.7 unaffected)
  • Component Integration Services (CIS)

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

Sybase, ASEServer, SAPASE, dataserver, CR817834, CR#817834 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

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.