SAP Knowledge Base Article - Preview

2679581 - Bad performance with M_VMCFA view for SAP ASE for BS

Symptom

  • Sequential Reads on table VBRK
  • Bad query plan / wrong index when quering  M_VMCFA view
  • Sample SELECT on M_VMCFA having performance issues:
    SELECT * FROM M_VMCFA
    WHERE "MANDT" = '100'
    AND "VKORG" = 'NLWS'
    AND "ERDAT" BETWEEN '00000000' AND '20180101'
    AND "RFBSK" IN ( '' , 'A' , 'B' , '_' , '_' , '_' , 'N' )


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

KBA , inefficient , plan , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.