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
- 25668 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 sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?
What is the use of program rsbdcsub? : abap bdc
Explain what is the difference between sy-tabix and sy-index? Where it is used?
While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization
How to analysis Background Job for performance Issue?
Explain what is an rdbms?
What is view? Different types of view. Explain?
Have you set up a back ground job? How to create a background job without a variant ? : abap bdc
What are the 3 methods that we use in sequence in a batch input session method? : abap bdc
What is luw or data base transaction ?
What are the requirements a dialog program must fulfill?
What is the structure of bdcmsgcoll? : abap bdc
How would you define the exponents for a type âfâ field?
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
performance tuning concepts
