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

What are the two levels in defining a match code? : abap data dictionary

590


Explain what is a logical database?

589


What are the advantages of logical databases?

612


Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?

1958


What is retro active accounting

1586






Can i Have Some Examples on Enhancements.

1968


What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary

1277


What is an on”*-input filed” statement?

596


I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr

561


What are the types of bdc s?

577


Exception handling and how does it transfer from called method to calling method?

858


how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?

1563


What are the modes in lock objects? : sap abap data dictionary

538


how can you display data say "your name"in sap script without print program or driver program??

1712


How to analysis Background Job for performance Issue?

758