SAP Knowledge Base Article - Preview

2723246 - Feature Enhancement: Numeric IDs added to showplan output for each POP operation in Abstract Plans - SAP ASE

Symptom

  • When looking at showplan output for complex queries, identification of physical operators becomes more difficult as query complexity increases
  • New feature added by CR 804186 (see KBA 2723236) attaches a numeric ID to each physical operator in showplan output to make identification easier
  • These IDs are not being printed in showplan for abstract plans (AP)

Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

performance, tuning, PFT, showplan, 11826, pop, abstract, plan, ap , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Product Enhancement

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.