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
- 25798 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
How can we use multiple transactions by using bdc_insert? : abap bdc
To how many tables can an append structure be assigned. : abap data dictionary
what is difference between set screen and call screen ?
after creating lock object if does n't access record by second user what should we do?
What are interface/conversion programs in SAP?
What are the function modules used in f4 help?
What are the different types of work process?
Control Break statements- At new...endat.
What is the different between template and a table?
What are the different types joins?
What is cts and what do you know about it? : abap hr
What is open sql?
Print options in smartforms?
In select-options, how to get the default values as current month first date and last date by default?
What is a subroutine?
