SAP Knowledge Base Article - Preview

2212229 - Performance problem for a DELETE statement on SLT Logging tables where the SLT source system uses an Oracle Database


  • Performance problem with 'DELETE from logging table' statement on the replication source system running on an Oracle database.
  • The problem happens when the daily statistics update is executed when the logging table is empty.



SAP Landscape Transformation Replication Server on DMIS 2011 (SLT 2.0) SP10 or earlier


SAP Landscape Transformation all versions


Wrong access plan; update statistics; Primary Index; IUUC_SET_LOGTAB_OPTIMIZER_STAT , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , HAN-DB , SAP HANA Database , BC-DB-ORA , Oracle , Problem

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.