In an Internal Table, I have 1000 records. I have to
Retrieve One Record. In Performence wise what is the Best
Query?
- 7 Answers
- 10124 Views
- I also Faced
- E-Mail Answers
Answer Posted / medepalli.sunil@gmail.com
1.READ TABLE ITAB WITH INDEX F1
2.Loop at itab where f1 and f2
-----
endloop.
out of these two the second has got the best performance
then the first one.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is difference between user exit, customer exit and badi?
Setting up a BDC program where you find information from?
What is the client concept in sap?
what is the t-code to link technical and functional operation?
What are the attributes of a field that can be activated or deactivated during runtime?
What are the two ways for restricting the value range for a domain? : abap data dictionary
What are the uses of secondary indexes?
What are the page headers for secondary lists?
Can we include customizing include or an append structure with pooled or cluster tables?
How can we set the table spaces and extent sizes? : abap data dictionary
How can we omit a leading sign and a leading zero in sapscript?
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
What are indexes? : abap hr
Define spool request?
performance tuning concepts
