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
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
How many secondary indexes can we create in a table?
Difference between Read and Get cursor?
Difference between top-of-page and top-of-page during at line- selection?
What is the bapi?
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....
When the get cursor command used in interactive lists?
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?
Name some system global variables you can use in abap programs?
What is the difference between call transaction and session method? : abap bdc
What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary
what is a text table ?
Of the two call transaction and session method, which is faster?
how to track records from data dictionary?