Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 24245 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / aditya
select single read db records with primary key.
select upto doesnt read for a primary key, instead it will
try to find the most suitable index.
hence select upto is faster than select single.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?
What is gui status? How to create /edit gui status?
Hi! I want to join SAP ABAP course in Hyderabad, can any one tell me where should I join? and Which is the best institute for SAP WORKSHOP? Thank you...
What is the bapi?
What is a function group? : abap modularization
Explain what are the system fields? Explain?
What is table pool?
How to create a check box/option button in a list?
What is PS structure
HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?
Can we access static attribute from instance method
what is bapi,badi,bdc,ale idocs?
What are two methods of modifying sap standard tables? : abap data dictionary
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
