Hi All,
1. What I understand is that using the "MODIFY" statement to update the database tables can cause performance issues when compared with using INSERT and UPDATE statements individually( to achieve the same task).
2. Because the system has to scan through the entire table records to check which record has to be inserted and which record has to be updated when an MODIFY statement is used, however I didn't find any recommendation from SAP to prefer using INSERT and UPDATE statements over MODIFY statement.
So, I want to make sure that my understanding(in point 1) is correct.
Please share your thoughts and ofcourse i'm only talking about Z* database tables