does select single *.. / select * .. affect performance ? how?
- 1 Answers
- 6048 Views
- I also Faced
- E-Mail Answers
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
Give few names of pooled tables in sap ?
Does the table can have multiple foreign keys?
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
What will you code in start-of-selection & end-of-selecton & why?
How is conversion of data types done between abap/4 & external level?
What are clustered tables?
How move-corresponding works
In which cluster time results are stored? : abap hr
What are the different types of mode (run code) in call transaction method?
What are standard layouts sets in the sap script?
What are roles and authorization objects?
Explain how do you use structures in the abap programs?
When, how and how would you control changes to standard SAP objects.
What is value table? : abap data dictionary
What is the differences between structure and table in the data dictionary in abap?
