What is the diffrence between select single * and Select
upto 1 row?

Answer Posted / chitta ranjan mahato

I am agree with the above answers given but I am to add
few lines.
Select Single can give you best performace when it is fired
with full primary key.
Select up to 1 rows is a special case of select up to n
rows.

there is almost no difference in performace in small
database. select single is used to check the avaviility of
particular record in database.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe data classes? : abap hr

633


How many types of size categories and data classes are there? : abap data dictionary

613


Name some data dictionary objects?

563


Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?

1672


How do you set up background jobs in sap? What are the steps?

538






Under Data Transfer Portion of ABAP, what do you mean by DX Project

1855


Can we set page headers to details lists?

590


What is pretty printer?

602


Explain difference between primary key and unique key?

523


What is locking ?

605


What are interactive reports?

638


How many types of views are there ?

647


What are the 3 methods that we use in sequence in a batch input session method? : abap bdc

577


What is buffering allowed but switched off?

869


To how many tables can an append structure be assigned. : abap data dictionary

593