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.