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 for Me (Login required).

Search for additional results

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