Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 26031 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / arjun manglekar
1)SELECT single retrives only one record which ever come
across first in data base query
SELECT ..upto 1 row , all records are fetched into a buffer
which are satisfied from Where condition in Data base
query , and from buffer first record is fetched .
>>same as Answer 2
2) If you know all the primary keys in WHERE condition ,
use SELECT single.
If you dont know all primary kyes in WHERE condition , use
SELECT...UPTO
3)Performance:
SELECT UP TO...is gives better performace than select single
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is a table pool? : abap data dictionary
Explain the difference between a dialog program and a report?
What are indexes? : abap hr
When will the current screen processing terminates?
What are the disadvantages of using explicit enhancement?
Explain client-dependent and client-independent tables.
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
What is a type-pool?
What is sap script? Describe its components.
Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?
What are the list of screen elements?
What are system fields for secondary lists?
Explain how to Handle the internal tables in ABAP?
Explain the client concept of sap.
What is erp? : sap abap hr
