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
- 26148 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
Explain the structure of a bdc sessions?
What is the t-code for transaction recorder? : abap bdc
What is sap abap data classes?
Explain the difference between tables and structures?
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
How do you use structures in the abap programs?
What two statements are required in an abap program to output an icon using a write statement?
What are client dependent objects in abap/sap?
Can a posting run be deleted? : sap abap hr
Explain the advantages of different types of bdc's?
What is a fall back class?
What is projection view?
How to define selection screen?
What are the aggregate objects in data dictionary? : sap abap data dictionary
What is abap work bench?
