what is the difference between standard and sorted
internal tables? (in performance wise)
Answer / vasu sistla
Standard tables:This is the most appropriate type if you are going to address the individual table entries using the index. Index access is the quickest possible access. You should fill a standard table by appending lines (ABAP APPEND statement), and read, modify and delete entries by specifying the index (INDEX option with the relevant ABAP command). The access time for a standard table increases in a linear relationship with the number of table entries. If you need key access, standard tables are particularly useful if you can fill and process the table in separate steps. For example, you could fill the table by appending entries, and then sort it. If you use the binary search option with key access, the response time is logarithmically proportional to the number of table entries.
Sorted tables:This is the most appropriate type if you need a table which is sorted as you fill it. You fill sorted tables using the INSERT statement. Entries are inserted according to the sort sequence defined through the table key. Any illegal entries are recognized as soon as you try to add them to the table. The response time for key access is logarithmically proportional to the number of table entries, since the system always uses a binary search. Sorted tables are particularly useful for partially sequential processing in a LOOP if you specify the beginning of the table key in the WHERE condition.
Is This Answer Correct ? | 5 Yes | 0 No |
What is the difference between skip and reserve?
What is the use of info groups? : sap abap hr
Among "Move" and "Move Corresponding", which is efficient one?
How do you read files from the presentation server ? : abap bdc
What are the differences between sap memory and abap memory?
User ‘A’ put the Exclusive Lock for one table and User ‘B’ want to put the Shared Lock for the same table. Is it Possible?
What are the different software packets available in the market? : sap abap hr
tell me about NGT?
Difference between user exit and badis?
Pls tell me, we r using at line-selection,at user-command and at pf-status for generating the secondary list in report then what we will use in ALV for generating alv list. pls tell me what r the important thing to read in alv for interview purpose.
what is the difference between transparent, pooled and cluster table
How i can make a enabled and disabled code using SAP ABAP? www.saponly.com