Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between standard and sorted
internal tables? (in performance wise)
- 1 Answers
- 7617 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
ABAP : Classical reports events name
What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary
How do you delete duplicate records from internal table?
What are the basic components of dialog program?
I am uploading 100 records out of which say 59th record has error so what will happen if I am using synchronous or asynchronous method of bdc? Can we update the database using local update mode how? : abap bdc
What are the different modules of sap? : sap abap hr
What are the types of views? : sap abap data dictionary
How can you find the field/data underlying a transaction?
While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization
foreign key enforcement?
What kind of financial periods exist in sap? What is the relavent table for that?
Can multiple abap systems connect to abap database?
What are the aggregate objects in the data dictionary? : abap data dictionary
How will you define org structure in MM?
What is the relationship existing between the various data elements? : abap data dictionary
