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

For all entires is more effiencent thatn the inner join , in
ineer jin we can only used up to 5 max of innerjoins inna
single statement.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the function module and a normal abap/4 subroutine?

638


What is the difference between table and template?

576


what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary

616


What is its?

659


What are the tcodes for performance tuning?

911






Explain the disadvantages of different types of bdc's?

516


What are the difference between tables and structures? : abap data dictionary

657


How many tables are there in sap?

645


What is at exit-command:?

570


What is the function of the transport system and workbench organiser?

637


where are the passwords for ITS stores?

1618


From excel to abap - is batch mode possible ? : abap bdc

628


Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc

686


Explain what is sap script? What is the purpose of sap script?

627


while implementing badi what are the tables u find??

3619