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 are the techniques involved in using sap supplied programs?

598


What is size category?

549


Why do we use types statement in abap programming?

661


when does a list get sent to the screen on the presentation layer?

1436


What is narrow casting and wide casting?

1126






Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc

662


Explain what is step-loop?

753


What are the payroll related infotypes? : abap hr

567


How to eliminate duplicate entries in internal tables? : abap data dictionary

776


In the MM module for finding out the standard cost what is the view one has to look at?

608


I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

1749


In which cluster time results are stored? : abap hr

581


What is the purpose of sum statement?

562


Suppose there is check box along with the rows. The requirement is, select the require check boxes and press a used defined button to save all these checked row data to another table. How can you do it?

1614


Explain the different types of data dictionary objects?

514