SAP Knowledge Base Article - Preview

2811475 - Pushdown sql generated when using the same datastore degrades job performance- Data Services


  • Jobs that use the same datastore for source and target tables will generate an INSERT INTO optimized sql and have slow performance.
  • Jobs that use different datastores, but connect to the same database, for source and target tables will generate an SELECT INSERT optimized sql and run quicker.
  • Why is the performance different?



SAP Data Services


SAP Data Services 4.2


KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , How To

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.