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

How are the function code handles in flow logic?

1042


How to handle errors in call transaction bdc method without using bdcmsgcoll internal table? : abap bdc

1145


Can you define a field without a data element? : abap data dictionary

1120


What will you code in start-of-selection & end-of-selection ?

1040


Difference between /N and /BEND?

1219


What is the purpose of at first and at last?

1082


What are number ranges?

1014


5) How to rereive text elements in SF and script?

2130


What is meant by search help? : sap abap data dictionary

1114


What is the difference between open_form and close_form?

1060


Explain the advantages/disadvantages of logical databases?

989


Name the special commands of list?

1093


Can a filed occur in several field groups?

992


How can we create callable modules of program code within one abap/4 program?

1071


can anybody give me functional specification (or table name & field names) of stock analysis report, work in progress report,generating vendor detailed list

1933