2345319 - ASE chooses wrong plan when compatibility mode off - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2345319 - ASE chooses wrong plan when compatibility mode off - SAP ASE

Symptom

  • SAP Adaptive Server 15.7 chooses wrong plan when compatibility mode is  off
  • ASE should choose unique clustered index "pk_NF_Header". Instead, ASE chooses nonclustered index "fk4_NF_header".

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7

Keywords

index, cluster ratio, statistcs, min/max , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.