which of the following is more efficient when we are
retrieving data from more tables.
select statement using innerjoins or select statement using
for all entries?
Answer Posted / joydip
One Single Inner join between database tables is much
faster than multiple For all entries.Also we may have to
create more internal tables in ABAP code to avoid one inner
join, which is not referable.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?
ABAP : Classical reports events name
What happens if a function module runs in an update task? : abap modularization
What is the symbol to do “concatenation” operation in nw abap 7.4 ?
What are the different methods of bdc? : abap bdc
In events, start-of-selection is a default event. When we have to use this event explicitly? Why?
What are the dis-advantages of logical databases? : abap hr
How do you Export a session ?
How to display or know if the value entered contains records or not?
Explain the differences between sap memory and abap memory?
What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?
How to debug rfc function module?
What is the sap abap?
What is the table & field to identify the no of items (bottles) stored in one case?
Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button