Question Re: CDS view vs ABAP Open SQL performance in Technology Q&A

CDS view vs ABAP Open SQL performance

Former Member — Mon, 28 Aug 2017 09:15:42 GMT

Is CDS view increases the performance compares to OPEN ABAP SQL? If so how?

Is Select * statement on CDS view degrading the performance or it yield same performance as Select * in normal ABAP Open SQL?

Please let know

Re: CDS view vs ABAP Open SQL performance

retired_member — Mon, 28 Aug 2017 09:32:07 GMT

"Is CDS view increases the performance compares to OPEN ABAP SQL?"

No.

"Is Select * statement on CDS view degrading the performance or it yield same performance as Select * in normal ABAP Open SQL?"

This question makes no sense. There is no abnormal vs. normal Open SQL.

Re: CDS view vs ABAP Open SQL performance

anversha_s — Mon, 30 Oct 2017 10:45:55 GMT

Regarding CDS view with SQL functions vs ABAP Open SQL performance -- My observation is code push down through CDS will improve the performance. Please refer my blog. How ever from AS 7.5 onwards there will not be any major difference as it varies based on the business scenarios

https://blogs.sap.com/2017/10/26/how-fast-is-abap-core-data-servicecds/

Re: CDS view vs ABAP Open SQL performance

kyo_choi73 — Fri, 24 Jun 2022 13:25:41 GMT

It will definitely increase the performance with added codes moved down to CDS Views and it definitely reduces the network traffic. From my past project experiences, in certain instances, it increased over 1000% from regular reports; it wasn't compared with the native SQL.

Re: CDS view vs ABAP Open SQL performance

retired_member — Mon, 27 Jun 2022 13:31:03 GMT

Of course, moving from old fashioned Open SQL to improved data models involving ABAP CDS can improve performance. But code push down is also possilble with modern ABAP SQL features (expressions, joins, subqueries, ...).

From a technical perspective, a simple CDS view is not better in performance compared to the respective ABAP SQL statement. Both generate the same SLECT statements on DB-level in the end.