topic Re: Sorting is required before delete data from internal table? in Application Development and Automation Discussions

Sorting is required before delete data from internal table?

Former Member — Fri, 03 Apr 2015 15:26:53 GMT

Hi All,

I have small confusion about internal table performance i.e. if we use sort operation on internal table before delete data form same table then it will increase performance or no effect in performance if don't use sort operation.

For example : In one table have 1000 records and i have to delete data by condition (eg. item name) which is at 900 index,

if we use sort operation before delete then it increase performance or not?

Thanks in Advance.

Shanti

Re: Sorting is required before delete data from internal table?

prad_k — Fri, 03 Apr 2015 15:45:00 GMT

Sorting is necessary only if you want to delete duplicate records from internal table.

Re: Sorting is required before delete data from internal table?

Former Member — Fri, 03 Apr 2015 16:35:07 GMT

Thanks pradeep for reply.

But my question is not for adjacent duplicates.

When we use delete ittab where f1 = 'f_value'. (characters)

If use sort before this operation then delete operation perform faster or not?

Re: Sorting is required before delete data from internal table?

prad_k — Fri, 03 Apr 2015 17:00:22 GMT

Not necessary, Based on type of internal table the system performs the search to delete the record.

Standard table uses Linear Search.

Sorted tables uses Binary search.

Hashed Tables will use Hashing Algorithm.

It is mandatory to sort while deleting duplicate records only.

Please go through the link below.

http://help.sap.com/saphelp_470/helpdata/en/06/aafd54fc4011d195280000e8353423/content.htm

Regards

Pradeep Kodinagula.

Re: Sorting is required before delete data from internal table?

Former Member — Fri, 03 Apr 2015 17:17:48 GMT

Thanks for Helpful Answer.