SAP HANA Query Optimization techniques
Author(s): Kumail Saifuddin Saif
Publication #: 2412122
Date of Publication: 07.12.2020
Country: USA
Pages: 1-6
Published In: Volume 6 Issue 6 December-2020
DOI: https://doi.org/10.5281/zenodo.14566278
Abstract
Query performance is a key aspect for any development done in SAP HANA and it is very common to have performance issues when the data size grows in the system. SAP HANA offers effective tools and techniques for developers to make sure the query is optimized as per the hardware of SAP HANA database. Understanding the details of Query processing by different HANA engines like Calculation engine, Join engine, OLAP engine to name a few, and the role of the SQL optimizer, SQL plan cache, PlanViz, OOM dumps helps developers to write and test the code to make sure performance is optimized.
Keywords: SAP HANA, Query Performance, SQL, Performance optimization, SQL optimizer
Download/View Count: 158
Share this Article