Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 22956 Views
- CSC, I also Faced
- E-Mail Answers
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
Advantages and disadvantages of different types of bdc's?
How can you access the function code from menu painter?
What is asap methodology? : sap abap hr
Normally how many and what files get created when a transaction program is written?
how to update the filed value in SAP in ZAWSYS and create time and date? please tell me the answer
What is the difference between tables and structures?
How do you read files from the application server ? : abap bdc
Normally how many and what files get created when a transaction program is written? what is the XXXXXTOP program?
What is the max no of match code id's that can be defined for one match code object? : abap data dictionary
What are function modules?
What two statements would be used to exchange data between programs using abap memory?
What are the two statements which are required in an abap program to output an icon using a write statement?
What are pooled tables? : abap data dictionary
What is an abap instance?
What data is contained in data dictionary? : abap data dictionary
