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

Answer Posted / nyk

select *
from <itab>
upto 1 row.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you populate data into a multiple line field? : abap bdc

622


What is the difference between a pool table and a transparent table and how they are stored at the database level?

585


What are the dynapro keywords?

667


On which even we can validate the input fields in module progams?

583


The max number of calling modes stacked at one time is?

587






​​Can multiple abap systems connect to abap database?

599


What is an “on request field” statement?

649


Can anyone done BDC/LSMW/BAPI for F-02 and F-04.If yes let me know the processs

1856


How does the interface between the dynpro and the abap/4 modules take place?

555


Is there any method apart from bdc for data upload to sap? : abap bdc

611


How do you find the information on the current screen? : abap bdc

605


How to write a bdc – how do you go about it?

659


Can a transparent table exist in the data dictionary but not in the database physically?

630


What is the difference between the exits created in M.M and S&D?

1609


Difference between sy-tabix and sy-index? Where it is used?

531