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
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
Lock objects and what are parameters of ENQUEUE FM?
What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc
Difference between stand alone CRM and back-end CRM
What are the system table used in abap?
Example of table cluster and cluster tables.
10) How to get Item Header in Sales Order?
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
What was the requirement of IDoc in your project? How it was working?
Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.
What is the use of dequeue function module? : sap abap data dictionary
what are Hana Basics
What are the functions of lock objects?
what are the two methods of modifying sap standard tables? : abap data dictionary
Do you know any other patterns if yes.. explain