Comparing INTO DATA VS FIELD-SYMBOL To Update Internal Table

When you want to update records of an internal table using LOOP ENDLOOP. The most common practice would be copying each row into a working are (INTO DATA) and modify the internal table afterwards. Many developers still unaware of the performance issues caused by this technique. In this tutorial, we’ll do a comparation between INTO…

How To Get 99% Faster With Parallel Cursor

When processing header and details records, we often used NESTED LOOP to update certain records from inside the loop. Unfortunately this technique will lead to significant performance issues, especially when dealing with large datasets. This method (NESTED LOOP) slows down your program and impacts efficiency and that’s why we will learn how to implement another…