Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
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 the BAPI_CUSTMATINFO_GETDETAILM used for? what is the input and output of this bapi.
What is Buffering Concept? When should a Table be buffered?
How does the interection between the dynpro and the abap/4 modules takes place?
Can you delete data element, which is being used by table fields. : abap data dictionary
What are the system table used in abap?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
What is a subscreen? How can we use a subscreen?
What are the events used in interactive reports?
What is a maintenance view? : abap data dictionary
What does the ‘suppress dialog’ do?
How can you distinguish between different kinds of parameters?
What are the functional areas, user groups? How does abap query work in relation to these?
What is lock objects? : sap abap data dictionary
What are the various types of selection screen event?
There is 1 person but it’s displaying that this person cannot be booked. He is not available for the business event. Can you tell me where is it going wrong? What can be the reasons? : sap abap hr