Skip to Content
Sep 04, 2019 at 07:27 AM

Performance difference between Select query with DBCO and CDS/AMDP


I am working on code optimization assignment where we are thinking of improving performance of queries by converting them from ABAP OpenSQL SELECT with CONNECTION to HANA Database to equivalent CDS/AMDP.

OPEN SQL SELECT queries are already using new 7.4 syntax to use statements like CASE.

As OpenSQL query will be converted by DB layer to subsequent HANA executable SQL, so is there any difference in performance by replacing ABAP open SQL with CONNECTION to HANA DB with CDS or AMDP?

I have been doing research from SAP Blogs/Articles but could not find comparison between these scenarios.

Thanks in advance for your help!