what is the difference between select single *
and slect upto 1 rows...
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 dialog module?
How to convert the Unit for 'Distance' (The value from one Unit to another).
Does the external program run in the same sap luw as the caller, or in a separate one?
Why grouping of fields is required? What is the max no of modification groups for each field?
What are the page windows?
What are the different types of data dictionary objects? : abap data dictionary
What is the function of a data element? : abap data dictionary
Mention what is alv programming in abap?
What are function modules?
How to add a column to a table control while using alphanumerical layout editor ?
What is web dynpro for abap?
What is native sql?
Example of table cluster and cluster tables.
What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?
Difference between domain and data element? What are aggregate object?