SAP Knowledge Base Article - Preview

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

Symptom

  • 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?


Read more...

Environment

SAP Data Services

Product

SAP Data Services 4.2

Keywords

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.