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

does select single *.. / select * .. affect performance ? how?

Answer Posted / kumar bgk

select single * ---> retrieves all the records in that
particular row defined by our selection citeria.
select * ---> retrieves all records from all the coloumns of
the table i.e., the entire table.

so the time consumed in retrieving all this information is
very high atleast in terms of programming and so it
significantly affects the performance.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use logical blocks in abap program?

2027


Explain what are the problems in processing batch input sessions? How is batch input process different from processing on line?

1017


What is abap work bench?

1239


What is a data dictionary? : sap abap data dictionary

920


What is pnp-sw-found ? : abap hr

1389


What is a currency factoring technique?

1164


How to upload data using catt ? : abap hr

1063


What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization

1047


Explain the Importance of pa20? : abap hr

1081


Name the function module used to convert logical file names to physical file names in abap/4 programs?

1109


Explain what is the difference between primary key and unique key?

1070


What is internal payroll process? : sap abap hr

1022


What is difference between inner join and outer join?

1031


What is your approach for writing a bdc program? : abap bdc

979


Explain the difference between function group and function module?

1090