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 / 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


Please Help Members By Posting Answers For Below Questions

It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization

1364


What are interface/conversion programs in SAP?

1179


What is tcode se16. For what is it used. Explain briefly?

1073


What is the difference between skip and new-line?

1322


What are the different types of operators in the sap abap?

1133


What are the organizational related infotypes? : abap hr

1196


Final class

1550


Does every abap/4 have a modular structure?

1061


What happens Update command is used without where clause ?

1188


Explain the difference between float and packed data type?

1386


What is the difference between a structure and a table?

1141


How to Solve a Particular Ticket in Realtime ?

2305


List some of the many different ways that the sap standard functionality can be changed by a customer?

975


Have you set up a back ground job? How to create a background job without a variant ? : abap bdc

1091


what is field string ? & where we are using field strings?

1996