SAP Knowledge Base Article - Preview

2628625 - Slow performance saving and retrieving Shopping Carts - SAP ASE for BS

Symptom

  • SRM Shopping Cart queries are running very slow
  • SM12 is showing sequential read for following SELECT:
    SELECT DISTINCT I.SRC_GUID, I.QUAN_CF_E FROM BBP_PDIGP I INNER JOIN CRMD_ORDERADM_I A ON I.CLIENT = A.CLIENT AND A.GUID = I.GUID INNER JOIN BBP_PDHGP H ON I.CLIENT = H.CLIENT AND H.GUID = A.HEADER WHERE I.CLIENT = '100' AND I.SRC_GUID IN ( 0x00999999999999999999 ) AND I.QUAN_CF_E <> 0 AND H.VERSION_TYPE = ''


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Supplier Relationship Management (SRM) 7.0
  • SAP Supply Chain Management (SCM) 7.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0 ; SAP Supplier Relationship Management 7.0 ; SAP Supplier Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

  suboptimal plan, CRMD_ORDERADM table scan, sequential read, SRM , KBA , 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.