SAP Knowledge Base Article - Preview

3635325 - BW Query: Improving Performance of Near-Line Storage Access

Symptom

A BW Query is based on an InfoProvider (ADSO) with Near-Line Storage (NLS). The runtime to read the data from the Near-Line Storage based on SAPIQ takes longer than expected. The data volume transferred from the Near-Line Storage to the Hana database is higher than expected.


Read more...

Environment

  • SAP BW/4HANA All versions
  • SAP NetWeaver All versions

Product

SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP BW/4HANA 2023 ; SAP Business Warehouse all versions

Keywords

Near-Line Storage based on SAPIQ, optimizer statistics, HANA Virtual Table, Smart Data Access tables, Smart Data Access, NLS, Performance, SDA, SAPIQ, optimizer, statistics, optimized, optimized statistics, IQ server , KBA , BW-BEX-OT-DBIF , Interface to Database , BW4-AE-CORE , Core Services , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-DBIF , DB Interface Data Manager , Bug Filed

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.