Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
Answer Posted / s.k.
Hi All ,
Actually in Select single * only one record is fetched
which ever come across first in data base query , but for
statment 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 .
So Select Single * is better for performance.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization
What are interface/conversion programs in SAP?
What is tcode se16. For what is it used. Explain briefly?
What is the difference between skip and new-line?
What are the different types of operators in the sap abap?
What are the organizational related infotypes? : abap hr
Final class
Does every abap/4 have a modular structure?
What happens Update command is used without where clause ?
Explain the difference between float and packed data type?
What is the difference between a structure and a table?
How to Solve a Particular Ticket in Realtime ?
List some of the many different ways that the sap standard functionality can be changed by a customer?
Have you set up a back ground job? How to create a background job without a variant ? : abap bdc
what is field string ? & where we are using field strings?