Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 25683 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
What are types of select statements?
What abap statement will trigger list generation?
What are the function modules used in f4 help?
What is tcode se16. For what is it used. Explain briefly?
Can i Have Some Examples on Enhancements.
How to split one Invoice into Multiple ( Step by Step)?
What are the different types of work process?
What are the list of screen elements?
What is design pattern? Provide example .Why are we using it?
Where do you use help views?
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
Explain the advantages/disadvantages of logical databases?
What is the difference between field-group header and other field groups?
What is an on”*-input filed” statement?
