Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between select single *
and slect upto 1 rows...
- 3 Answers
- 9885 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 are the function modules used in a sap script driver program?
What is asynchronous update?
What are the Synchronous and asynchronous methods in bdc ?
What is its? : abap hr
Is the basic list deleted when the new list is created?
Explain the different types of mode (run code) in call transaction method?
What are the differences between a database index and a match code? : abap data dictionary
Why do we use abstract class
What are the aggregate objects in data dictionary? : sap abap data dictionary
How the transaction that are programmed by the user can be protected?
What are the rules to create a BAPI?
How many main windows are allowed in sapscript?
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
what is the transaction transaction for setting parameters rdisp/buffermode
Can i Have Some Examples on Enhancements.
