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 significance of delivery class? : abap data dictionary
What is the difference between the function module and a normal abap/4 subroutine?
What is the difference between collect and sum?
How to read files and process BDC's automatically ?
Workbench request are client dependent or client independent
What is a table attribute? : abap data dictionary
On which event we can validate the input fields in module programs?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
What are the basic functions of database utility?
In which table the material master data is stored?
What is the difference between select statement and provide statement ? : abap hr
What is difference between check table and value table ?
What are the differences between session method and call transaction method? : abap bdc
What is modularization and its benefits?
What is the difference between Classic badi and Kernal badi ?