Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 23004 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
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
Explain what are the events in screen programming?
what is abstract classes
How to eliminate duplicate entries in internal tables? : abap data dictionary
Name the special commands of list?
Explain the disadvantage of using exec sql statement in abap?
What are the differences between session method and call transaction method? : abap bdc
What are the dynamic actions and how to configure it? : sap abap hr
What is generic area buffering in abap?
What is the maximum number of structures that can be included in a table or structure
Explain the different types of mode (run code) in call transaction method?
What are the parameters used in each function?
How to pass data from list to report?
WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.
What are null values?
