In an Internal Table, I have 1000 records. I have to
Retrieve One Record. In Performence wise what is the Best
Query?

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


Please Help Members By Posting Answers For Below Questions

What are the personnel administration related infotypes? : abap hr

608


What is alv programming in abap?

638


In a loop of an internal table, what is the use of at first & at last statements?

1473


What is foreign key relationship? : abap hr

615


What is an abap instance?

606






Can you assign a matchcode object to a parameter? If so how?

596


What are the ways you can do the tuning?

524


What are the client dependant objects in abap / sap?

533


Can you delete data element, which is being used by table fields. : abap data dictionary

664


Explain open dataset in sap abap?

797


What are the page windows? How many main windows will be there in a page window?

557


How do you take care of performance issues in your ABAP programs?

663


What is the tcode for sapscript forms?

654


Difference between sy-tabix and sy-index? Can you check sy-subrc after perform?

637


Does sap handle multiple currencies?

605