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
Why do we use logical blocks in abap program?
Explain what are the problems in processing batch input sessions? How is batch input process different from processing on line?
What is abap work bench?
What is a data dictionary? : sap abap data dictionary
What is pnp-sw-found ? : abap hr
What is a currency factoring technique?
How to upload data using catt ? : abap hr
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization
Explain the Importance of pa20? : abap hr
Name the function module used to convert logical file names to physical file names in abap/4 programs?
Explain what is the difference between primary key and unique key?
What is internal payroll process? : sap abap hr
What is difference between inner join and outer join?
What is your approach for writing a bdc program? : abap bdc
Explain the difference between function group and function module?