Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SORT and DELETE ADJACENT

hi,

why do we need used the SORT and DELETE ADJACENT if there is a warning msg stated

"Before For ALL Entries internal tbl remove duplicate values" and what are the cause of the issue if we dun not put it ?

Thanks

Tags:
Former Member replied

Sorting and deleting adjacent entries before select all entries statement will help in improving the performance of the select statement.

Also, if there are any duplicate entries in source table, it results in duplicate efforts to fetch the data from database.  You can verify this by doing SQL trace ST05 on that query.

When you use for all entries, the system basically splits the query in multiple queries and fetches data and then deletes any duplicates from the resultant table if any.

Check this link which explains the process, the issue and solution.

http://zevolving.com/2012/05/performance-of-using-keys-in-select-with-for-all-entries/

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question