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 / mayuri

inner join is more efficient

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Static and instance variable and method with live example. Why and when to use

920


How to copy table across clients?

616


what are the various types of parameters and how are they distinguished from one another?

717


How do you process errors in call transaction method? : abap bdc

670


What is pnp-sw-found ? : abap hr

857






What is the difference between bdc_okcode and bdc_cursor? : abap bdc

606


Can we create field without data element? If yes, how?

688


What are the components of sap scripts? : abap hr

576


PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'

3681


What are conditional chain statement?

742


What are the different modules of sap? : sap abap hr

545


What is a multiple line field?

584


What are the differences between session method and call transaction method? : abap bdc

545


Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.

1574


How do you backup Sapscript layout sets? Can you download and upload? How?

622