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 is the lock object?

610


What is a collect statement?

581


What are the differences between the table and the structure in the data dictionary in the sap abap?

599


What will you code in start-of-selection & end-of-selecton & why?

589


What is the use of a pretty printer?

617






Explain the difference between open_form and close_form?

551


What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?

696


When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization

622


What are null values? : abap data dictionary

627


hi frends this is bala raju from pune.i want to know diff between 4.7ee and ecc 5.0.if possible give me brief explanation.this question was asked in EDS(tele interview) in pune bye.

1714


What is a table cluster? : abap data dictionary

742


What are the time related infotypes? : abap hr

627


What happens if we use leave to list-processing without using suppress-dialog?

703


Difference between /N and /BEND?

828


visibility section for class level and attributes level

821