what is the difference between select single *
and slect upto 1 rows...
- 3 Answers
- 8545 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
What is the difference between Classic badi and Kernal badi ?
What is a subscreen? How can we use a subscreen?
Explain pai and pbo.
Define abap/4 layer? : abap data dictionary
What are base tables of an aggregate object?
Explain the data types of internal tables?
Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?
What are your ways to performance optimization?
What is the difference between ABAP and HR ABAP
What are differences between at selection-screen and at selection-screen output?
What are the types of subroutines? : abap modularization
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
What is page window?
What is buffering in abap?
What was the requirement of IDoc in your project? How it was working?
