About former_member184455

former_member184455 · 12-20-2018

In this blog post on the performance aspects of CDS views, I want to discuss how good performance can be ensured when building and accessing CDS views. Basically, it’s all about simple SQL performance rules that sometimes sink into oblivion when work...

former_member184455 · 11-28-2018

In this blog post I describe how the HANA optimizer creates an execution plan from your SQL statement, how this plan wanders into the plan cache and what you should consider when analyzing the SQL statement from HANA studio. Since my main interest is...

former_member184455 · 11-15-2018

In this series of blog posts, I want to discuss some performance aspects of ABAP CDS views. As a performance expert daily working on CDS view performance topics I hope to be able to give some insights from my experience. I roughly plan to cover the ...

former_member184455 · 02-11-2014

Did you know that it is possible to analyze the SELECT statements of an SQL trace with the Code Inspector check tool? You'll find that ‘not all too well documented’ function of transaction ST05 when displaying the SQL-Trace in the menu under Goto -...

former_member184455 · 07-26-2011

In the previous blogs of this series (see below) the objects that were investigated with the Code Inspector were 'program-like', that is reports, function groups, or ABAP OO classes.Code Inspector performance checks series:Code Inspector's Performanc...

former_member184455 · 10-07-2021

Hi Kalyan, Yes, that's true, the parameter-aware optimization is done in the (re-)creation of a plan during the first statement execution, using the parameters of this first execution. In following executions the plan is reused and not again optimiz...

former_member184455 · 09-07-2021

Hi Mustafa, One possible reason for 'RECOMPILE TRIGGERED DUE TO PARAM VALUES' is that HANA assumes that the existing plan is no longer optimal (which can happen f.e. due to compression or merge of tables). The plan is then recompiled using parameter...

former_member184455 · 11-26-2019

i Mayank Jaiswal, Every condition in a WHERE-clause or parameter used to access a CDS view potentially can be pushed down to table level - if the underlying data model allows it and optimizer finds a way to do it. This is independent of the @Consump...

former_member184455 · 07-11-2019

Hi Daniel,I now asked development whether they want to suppress the message if any of the involved tables is buffered.From performance point of view the situation is not straightforward if a buffered table is involved in SELECT + SELECT ... FOR ALL E...

former_member184455 · 07-10-2019

Hi Gijsbert, which HANA revision do you have?

User Statistics

User Activity

Safeguard Performance of ABAP CDS Views – Part 3 Rules for Good Performance of CDS Views

Safeguard Performance of ABAP CDS Views – Part 2 HANA SQL Optimizer and Plan Cache

Safeguard Performance of ABAP CDS Views – Part 1 CDS View Complexity

Code Inspector Integration into SQL Trace of ST05

Code Inspectors Performance Checks (IIII)

Re: Safeguard Performance of ABAP CDS Views – Part 2 HANA SQL Optimizer and Plan Cache

Re: Safeguard Performance of ABAP CDS Views – Part 2 HANA SQL Optimizer and Plan Cache

Re: Safeguard Performance of ABAP CDS Views – Part 3 Rules for Good Performance of CDS Views

Re: Some strange behavior/checks of ATC

Re: Safeguard Performance of ABAP CDS Views – Part 2 HANA SQL Optimizer and Plan Cache