The query performance is equal to or better than a scenario where SAP NetWeaver BWA is used:

Complex analysis and planning scenarios with unpredictable query types, high data volume, high query frequency and complex calculations can be processed with a high degree of efficiency, as read accesses are in-memory optimized.

In addition, the query performance on DataStore objects is comparable to the performance on InfoCubes.

Load processes in SAP HANA-optimized Data Warehouse objects can be processed with a high degree of efficiency.

The SAP HANA database replaces both the previous database and SAP NetWeaver BWA, thus contributing to a reduction in infrastructure costs. Instead of database administration and additional SAP NetWeaver BWA administration, the SAP HANA database requires just one set of administration tools, for monitoring or backup and restore for example.

Data modeling is simplified. Using in-memory optimized objects means that it is not necessary to load to a BWA index for example, while the database architecture allows you for example to delete characteristics from an InfoCube that still contains data. Loading data from a DataStore object into a downstream InfoCube can also become unnecessary, if the InfoCube is only there to improve query performance.

Thanks to its high compression rate, the column-based data store ensures that less data needs to be saved. Column-based storage is used for all InfoProviders that save data. The property "SAP HANA-optimized" improves performance even further.