Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between select single *
and slect upto 1 rows...
- 3 Answers
- 9935 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
How do we handle multiple line items in BDC's.
The commands through which an abap/4 module can “branch to “ or “call” the next screen are?
How many types of buffering? : abap data dictionary
What are the advantages of logical databases?
What is interactive reporting?
What are the system fields?
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
Explain what is a foreign key relationship? Explain this with the help of an example.
How can we access the correction and transport system?
What is the different between abap and ooabap? Why do we use ooabap?
Hat are the different types of mode (run code) in call transaction method?
What is a development class? : abap data dictionary
WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.
What are the events used in interactive reports?
what are Hana Basics
