In an Internal Table, I have 1000 records. I have to
Retrieve One Record. In Performence wise what is the Best
Query?
Answers were Sorted based on User's Feedback
Answer / sathish
Use READ TABLE STATEMENT
READ TABLE <ITAB> INDEX 1.
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / 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 |
Answer / ajay chowdary
READ TABLE ITAB WITH INDEX 1. is the best procedure.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / ravi
READ TABLE ITAB INTO WA WITH TABLE KEY F1 F2.. (PROVIDE FULL KEY).
OR
READ TABLE ITAB WITH INDEX 1.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / niladriroy_dgp
Select Single (with full primary key) is the best process
to fetch one record.
Is This Answer Correct ? | 2 Yes | 13 No |
In Open SQL statements such as Insert update delete which one is FASTlLY retrieve the results and which one is Efficient?
How can I trigger the outbound IDOC?
What is the difference between ECC versions and older versions?
What is alv programming in abap? When is this grid used in abap? : abap hr
when run my program in se38 it was showing output, when i take background execution and giving printer details it was shoing out put. but in SP01 when i give the Spool Request Number it was showing not yet processed entire page why it happens i dont know please give me a solution.
Can you print decimals in type n?
5) How to rereive text elements in SF and script?
What are the domains and data element?
What are internal tables? How do you get the number of lines in an internal table?
what is the use of control_form?
What is the function module to popup contents in the internal table?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.