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 / lalit mohan padhi

For all entries is more useful than inner join.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the prerequisites for creating foreign key relationship?

650


Can a domain, assigned to a data element be changed? : abap data dictionary

540


What are the advantages of different types of bdc's?

524


Explain what are standard layouts sets in the sap script?

927


What are the different types of the variable in the sap abap?

581






How can we achieve MVC ?

899


What is view? Different types of view. Explain?

578


What is the use of 'for all entries'?

593


Explain what is the difference between sy-tabix and sy-index? Where it is used?

551


What is the function module to popup contents in the internal table?

552


What are the arithmetic operators in the sap abap?

554


What is search help exit? : sap abap data dictionary

709


Name a few data dictionary objects? : abap data dictionary

673


How do you restrict the data to be entered in the payroll area? : sap abap hr

523


What is the advantage of structures?

574