Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ABAP syntax 7.5

ishwarya_doss
Participant
0 Likes
3,383

Hi All,

New ABAP syntaxes are easy to use. But, on considering the performance we got the below doubt.

New read itab statements are not performing binary search anywhere. When we use new READ syntaxes in ORACLE DB, it may affect the performance , right? As we always sort and do binary search in our traditional way

Please suggest!

1 ACCEPTED SOLUTION
Read only

keremkoseoglu
Contributor
2,018

Using hashed / sorted table whenever possible would increase the performance + they can be used within the scope of new ABAP syntax.

4 REPLIES 4
Read only

FredericGirod
Active Contributor
2,018

READ is a statement to read data from memory, not database, so no direct link with oracle.

If you want a binary search on a table, you just have to declare it as SORTED table

Read only

former_member1716
Active Contributor
2,018

anabaperlife,

I don't think you will have performance impact , recommend you to go through the below Threads which will help you with the answer.

THREAD1

THREAD2

Regards!

Read only

Jelena_Perfiljeva
Active Contributor
2,018

The "traditional" way you're describing was not good since the 1990s.

I sincerely hope that by "we" you are describing a college/training study group. The thought that professional ABAP developers are unable to distinguish between the DB and memory processing would be deeply troubling...

Read only

keremkoseoglu
Contributor
2,019

Using hashed / sorted table whenever possible would increase the performance + they can be used within the scope of new ABAP syntax.