Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
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
What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?
pls if any one have idea ,reply as soon as possible 1.Allied solution group inc. is a genuine company or not ? 2.what is update module. 3.Transaction: scc3 what it is?
Will 50,000 records be uploaded directly into APP's Server?
what is mean be On Change of in Control Break statement
How do you display a data in a detail list?
Difference between call by value and call by reference? : abap data dictionary
identify valid statement when coding a field exit ? a) submit RSCA101X b)MESSAGE E101 C)MESSAGE I101 d)BREASK-POINT
What is lock object ? : abap data dictionary
What is meant by write lock? : sap abap data dictionary
Event handling in oops
How to create user interfaces for lists?
What is the difference between a pool table and a transparent table and how they are stored at the database level?
What are uses of foreign key?
How to display or know if the value entered contains records or not?
Why do we use events and actions in web dynpro?