SAP Knowledge Base Article - Preview

2234135 - Bad query plan under optimizer setting 'avoid_bmo_sorts' for 'union all' query - SAP ASE

Symptom

  • A query with an "union all" clause
  • Executed under optimizer criteria avoid_bmo_sorts
  • Can result in a badly performing query plan using excessive table scans

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.