Performance difference between Select query with DBCO and CDS/AMDP

[saurabh_chikate]

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!

[mmcisme1 · Accepted solution]

Try it in a test program and compare the two.

You are not finding an answer because it depends. Also a poorly written select in your code with still be a longer execution time on HANA. Did you look at things like selecting on a key field, only bringing what you need back? In the CDS/AMDP did you use the available syntax like filter, expressions, grouping, etc. The idea is to do as much as you can on the database. And even then it depends on things like how much information are you processing.

[saurabh_chikate · Accepted solution]

Thanks a lot!

Now it makes sense 🙂