Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?

Answer Posted / aditya

select single read db records with primary key.
select upto doesnt read for a primary key, instead it will
try to find the most suitable index.
hence select upto is faster than select single.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you suppress the display of a parameter on the selection screen?

567


What are the fields in a bdc_tab table? : abap bdc

622


Which function module would you use to check the user’s authorization to access files before opening a file?

609


What are conversion routines? : abap data dictionary

594


How do you read files from the application server ? : abap bdc

613






What does hide statement do?

574


can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.

3047


Where are you used type casting?

916


Differentiate database index and match code.

599


what is the difference between Blocked ALV and interactive ALV?

1872


What are the classifications of the sap abap data classes?

612


What are interface/conversion programs in SAP?

594


In which cluster time results are stored? : abap hr

591


In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?

604


Can we access static attribute from instance method

999