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
- 26020 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
Define external layer? : abap data dictionary
Work most on which module: name a few tables?
What do you mean by transparent tables in sap abap? : abap data dictionary
What is a table cluster? : abap data dictionary
What is the difference between the exits created in M.M and S&D?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
What are the main events of which are used for logical database?
Explain different types of attributes of function module?
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
How to insert a line into abap internal tables?
Why cant we use Normal function module for data transfer?
What are the differences between sap memory and abap memory?
how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?
What is the significance of hide?
What is locking ?
