sap hana sql Blog

How to improve the performance of your SQL functions

How to improve the performance of your SQL functions

While other tools check the performance of the execution, i.e. the result of the written code, SQLScript Code Analyzer is used to check the code itself. This tool can be ...
More
SQL Performance Analysis with SAP PlanViz

SQL Performance Analysis with SAP PlanViz

In our first post, Performance analysis and optimization of SAP SQL, we presented different approaches to performance analysis of SQLScript. While the EXPLAIN PLAN ...
More
Performance analysis and optimization of SAP SQL

Performance analysis and optimization of SAP SQL

There are several ways to analyze SQLScript performance. In this article you will learn about the relevant tools. We will show you how to measure the runtime of your SQL ...
More
SQLScript Performance Tips

SQLScript Performance Tips

Performance is one of the main arguments for using SQLScript. With the introduction of the HANA database, SAP has introduced the "code pushdown" concept. With this new ...
More
Handling account & key figure model in SAP HANA SQLScript & CalcView

Handling account & key figure model in SAP HANA SQLScript & CalcView

In this blog post, we look at several variants for transforming or pivoting/unpivoting a dataset between the account model and the key figure model. For this purpose, we ...
More
Generation of SQLScript for SAP AMDP transformations with ABAP

Generation of SQLScript for SAP AMDP transformations with ABAP

Since SAP Release 7.40 SP05, BW transformations can be executed directly on the SAP HANA database if no ABAP routines are used. The use of SQLScript transformations can ...
More
Hana SQL DWH vs SAP BW vs Mixed Scenario - Quick Guide -

Hana SQL DWH vs SAP BW vs Mixed Scenario - Quick Guide -

Traditionally, the SAP Business Warehouse (BW) is the Data Warehouse (DWH) solution of choice. For companies with an SAP ERP system, this is the most obvious solution ...
More
How to use Window Functions in SQLScript

How to use Window Functions in SQLScript

In this article, we first define the term window function and describe how they work. Then we analyze the syntax elements of this function group and combine the shown ...
More
How to improve the performance of your SAP HANA database

How to improve the performance of your SAP HANA database

Without a doubt, our daily lives become increasingly data-driven and the amount of data is continuously increasing every day. Thus, the amount of data that is generated ...
More
How to use IF ELSE statements in SAP HANA SQLScript

How to use IF ELSE statements in SAP HANA SQLScript

In the previous article, "CASE in SAP HANA - Control flow for SQLScript Transformation Routines", you learned that IF ELSE constructs are not possible within a SELECT ...
More