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
- 26087 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
Which function module would you use to check the user’s authorization to access files before opening a file?
What is size category?
What is asynchronous and synchronous update?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
What are the two levels in defining a match code ?
What is the meaning of client independent?
What is buffering in abap?
What is an “on input filed” statements?
Name a few data dictionary objects?
Explain how to Handle the internal tables in ABAP?
What is open sql?
When the get cursor command used in interactive lists?
Difference between stand alone CRM and back-end CRM
What are client dependant objects in abap/sap?
how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul
