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 |
1. what r the step followed for ALE Idocs ? 2. what is process code ? where it is define ?
What are plan versions used for? : sap abap hr
i have a requirement that design window in layout of smartforms but when we print smartforms window should not be printed?
Print options in smartforms?
What is the use of table maintenance allowed?
How to combine multiple billing into one RV document ( Step by Step)?
SmartForm : how to print a smartform layout having one portrait and one landscape?
What is a data class? : abap data dictionary
difference between user-exit and customer-exit?
what is the use of field symbol?
how does SAP organise its exits?
What are the select-option fields?