Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?

1744


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?

1986


Will 50,000 records be uploaded directly into APP's Server?  

2383


what is mean be On Change of in Control Break statement

1281


How do you display a data in a detail list?

987


Difference between call by value and call by reference? : abap data dictionary

1081


identify valid statement when coding a field exit ? a) submit RSCA101X b)MESSAGE E101 C)MESSAGE I101 d)BREASK-POINT

2492


What is lock object ? : abap data dictionary

1122


What is meant by write lock? : sap abap data dictionary

1040


Event handling in oops

1528


How to create user interfaces for lists?

1012


What is the difference between a pool table and a transparent table and how they are stored at the database level?

1060


What are uses of foreign key?

1092


How to display or know if the value entered contains records or not?

1034


Why do we use events and actions in web dynpro?

1006