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


Please Help Members By Posting Answers For Below Questions

A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?

543


ABAP : Classical reports events name

903


What happens if a function module runs in an update task? : abap modularization

593


​​What is the symbol to do “concatenation” operation in​​ nw​​ abap​​ 7.4​​ ?

776


What are the different methods of bdc? : abap bdc

603






In events, start-of-selection is a default event. When we have to use this event explicitly? Why?

579


What are the dis-advantages of logical databases? : abap hr

609


How do you Export a session ?

1450


How to display or know if the value entered contains records or not?

580


Explain the differences between sap memory and abap memory?

538


What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?

558


How to debug rfc function module?

694


What is the sap abap?

633


What is the table & field to identify the no of items (bottles) stored in one case?

1980


Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button

1770