CDS view vs ABAP Open SQL performance

[Former Member]

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

[kyo_choi73]

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.

[retired_member]

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.