SAP Knowledge Base Article - Preview

3721771 - How to change Database reading Package Size for BW Query execution

Symptom

When executing BW Query, data is read from Database by packages. Default package size is 20000. That means 20000 records are returned from Database to BW by each package.
When the data column from Database is many times of 20000, there are many packages. It can happen that each package reading takes relatively long, which results in long query execution time.
In such situations, increasing Package Size may shorten the Query execution time.


Read more...

Environment

  • BW7.5
  • BW4HANA
  • S4HANA

Product

SAP BW/4HANA all versions ; SAP Business Warehouse all versions ; SAP S/4HANA all versions

Keywords

packagesize , KBA , BW-BEX-OT-DBIF , Interface to Database , BW4-AE-DBIF , DB Interface Data Manager , 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.