Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between select single *
and slect upto 1 rows...
- 3 Answers
- 9754 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 a logical database?
what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?
Differentiate between abap memory and sap memory?
How to find the return code of an stmt in abap programs?
What is luw?
What is modularization and its benefits? : abap modularization
What is For-period and In-period
Where the payroll results are stored
How can we declare a table control in the abap/4 program?
What is the reserve command?
What is the meaning of client independent?
Why do we use logical blocks in abap program?
Can a constructor be redefined?
What are match codes? describe?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
