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

What is the name of the system variable that holds the contents of the selected line in interactive reporting?

1206


How do we assign dynamic views while creating material master and generating bdc? : abap bdc

1138


How many secondary indexes can we create in a table?

1029


Difference between Read and Get cursor?

2052


Difference between top-of-page and top-of-page during at line- selection?

2333


What is the bapi?

1131


how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....

2082


When the get cursor command used in interactive lists?

1094


i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?

2181


Name some system global variables you can use in abap programs?

1005


What is the difference between call transaction and session method? : abap bdc

1203


What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary

963


what is a text table ?

2327


Of the two call transaction and session method, which is faster?

1175


how to track records from data dictionary?

2071