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

for all entries is the more efficient.

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is collect statement different from append?

586


Where can you find error log for call transaction? : abap bdc

715


How can we omit a leading sign and a leading zero in sapscript?

599


What are field groups?

595


What are the types of parameters in the function modules?

654






Did you create secondary index?

686


Explain the types of bdc's?

591


What are base tables of an aggregate object?

608


Define database layer? : abap data dictionary

665


How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?

611


Normally how many and what files get created when a transaction program is written? what is the XXXXXTOP program?

642


While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization

609


What are different ABAP editors? What are the differences?

584


Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary

607


What will be your approach towards optimizing legacy code? Will you suggest change in technology? Does OO ABAP bring any performance benefits? How will you deal with queries in a loop? How will you optimize nested loops?

896