Parallel Cursor Technique

[Former Member]

Hello,

Can some one give me a description in detail as to what exactly Parallel cursor method is and how it works.

Also, what are the Performance Tuning Techniques that we can follow during ABAP Development?

Thanks and Regards,

Venkat

[Former Member]

Hi Venkat,

Check this thread with the same topic:

Regards,

Chandra Sekhar

[Former Member]

Thread Answered.

Thanks and Regards,

Venkat Phani Prasad Konduri

[Former Member]

actually, I would not recommend the parallel cursor technique! First name is actually incorrect internal tables have no cursor only indexes, only parallel

index would make sense.

Performance improvement:

If costs for sort are taken into account, then parallel index is not faster than loop with loop on sorted table.

or with standard table

loop
    read ...  binary search
    index = sy-tabix    
    loop ... from index
       if  ( condition is not fulfilled )
          exit
       endif.
    endloop
endloop

The full parallel index technique should find all deviations between 2 tables, additional lines in Tab1, additional lines in tab2, changes.

Feel free to find a complete solution. We can compare results, it is not worth the effort!

Siegfried