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
Print options in smartforms?
Name a few data dictionary objects? : abap data dictionary
When the top-of-page event does get triggered?
What are logical data bases used in hr module? : abap hr
What are two methods of modifying sap standard tables? : abap data dictionary
Have you set up a back ground job ? How to create a background job without a variant ?
If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary
Explain the advantages and disadvantages of different types of bdc's?
What is the difference between data elements and domains? : abap data dictionary
How collect statement is different from append?
What is the meaning of sap r/3?
What is the tcode to create indexes?
How many detail lists can be created in interactive reporting?
What are the types of views? : sap abap data dictionary
What is the use of dequeue function module? : sap abap data dictionary