what is the difference between select single *
and slect upto 1 rows...
- 3 Answers
- 9065 Views
- I also Faced
- E-Mail Answers
Answer Posted / anita
select up to one rows is much quicker that select single
as your not really using the all the key fields. Select
single is a construct that is designed primarily to read
database records with a primary key. If there is no primary
key available then at the most it might end up doing a
perfunctory sequential search. However in the case of
select up to one rows it will assume that there is no
primary key and will automatically search for the most
appropriate index.
In select * single only a single record is fetched that is
whichever one will come first in the data base query. But
in the case of select upto one rows all the records will be
fetched and stored in a buffer which pertain to the where
condition in the Data base theory.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Which objects are independent transport objects? : abap data dictionary
how do you call third selection screen ?
hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp
How do you write transaction programs in sap?
What is abap?
What are screen painter? Menu painter? Gui status?
Can a constructor be redefined?
What are the personnel administration related Infotypes
Can we set page headers to details lists?
Did you create any joins?
How to find Kernal badi ?
Explain enhancements
How to select valid lines for secondary list?
What is the disadvantage of a call by reference? : abap modularization
What is the transaction code to display the payroll results ? : abap hr
