Answer / arjun manglekar

1)SELECT single retrives only one record which ever come
across first in data base query

SELECT ..upto 1 row , all records are fetched into a buffer
which are satisfied from Where condition in Data base
query , and from buffer first record is fetched .

>>same as Answer 2

2) If you know all the primary keys in WHERE condition ,
use SELECT single.
If you dont know all primary kyes in WHERE condition , use
SELECT...UPTO

3)Performance:
SELECT UP TO...is gives better performace than select single

Answer / guest

Use Select single if all the primary keys are provided else
use select up to 1 rows as that would be faster.I agree
with Aditya..

Answer / s.k.

Hi All ,
Actually in Select single * only one record is fetched
which ever come across first in data base query , but for
statment select ..upto 1 row , all records are fetched into
a buffer which are satisfied from Where condition in Data
base query , and from buffer first record is fetched .
So Select Single * is better for performance.

Answer / vijayaraghavan

Select Single * will pickup only one matching record from the database into the buffer, and returns the same to the internal table.

Select upto 1 rows will pickup all the records matching the condition into the buffer, but return the top record to the internal table.

Answer / vasu

i agree with aditya but if u know all primary key feilds in
that case only u go for select single *..other wise always
select up to n is the best..

Answer / 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.

Answer / stefan wagenblast

As looking on the performance analysis (ST05), both SELECTs
have the same estimated costs (I made a test). So because
estimated costs com from the database system, the same way
of searching in the table will be used --> no difference
which SELECT you use.

Answer / laxmi_nv

Select .. Up to one row will have better performance than
the Select single *

Answer / manoj kumar

select single * its complsary to use prmary key where as
selectup to one row there is no need of key and it will get
only one record where as in select single we will get
multiple record based on selection criteria

2. wat is sub screen?

1 Answers  

In BDC,i have 3 transaction and one flat file with data for all those 3 transaction requires........i want to process these 3 transaction at a time using that single flat file,if 3rd transaction fails to upload the record,can we roll back the remaining 2 transaction or we can't?Is it possible in BDC,How?

2 Answers   IBM,

explain the script component in script?

2 Answers   TCS,

how will u interact with client if neccessary?

3 Answers   Accenture, Satyam,

what is enhancement and modification ? Explain clearly please

2 Answers   Keane India Ltd,

We execute the BDC program in foreground and got list in C drive. If the same program we can execute in back ground what happen?

2 Answers  

What is a data class? : abap data dictionary

0 Answers  

IN Smart Form how many windows are there explain them each? Upto how many main windows we can place in Smartform?

4 Answers   Accenture, HP,

What are the different attributes that can be assigned to a variant?

0 Answers  

What are the components of sapscript?

0 Answers  

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?

7 Answers   Sony,

what are views? And how many types of views are there?

6 Answers