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 / amit pradhan

For Key Field Inner Join is most appropriate on the non-key
field for all entries is best

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

singleton class

933


How to write a code in tab control? : abap bdc

634


What are the aggregate objects in the data dictionary? : abap data dictionary

1048


What is the procedure you followed to upload the data?

570


What are the tcodes for performance tuning?

911






What is repository info. Systems? : abap data dictionary

584


How is collect statement different from append?

590


There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue

7580


What does hide statement do?

569


what are the two methods of modifying sap standard tables ?

556


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

672


Can we make use of flow logic control key words in abap/4 and vice-versa?

595


What happens if only one of the commands set screen and leave screen is used without using the other?

595


Are you familiar with all steps for setting up a workflow?

1673


What are local objects? : abap data dictionary

603