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 / ravi gupta

inner join is more efficient

Is This Answer Correct ?    2 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

stock transfer from one plant to another plant ? i want the total description.

1576


what is diff between idocs,bdc,rfc and bapi. give real time answer

17731


What is meant by performance analysis? Have done anything to improve the performance?

558


How many types of data classes are there in sap abap? : abap data dictionary

554


I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.

1351






How to create a link between modified form and modified print program?

585


Can you define a field without a data element? : abap data dictionary

623


Which bdc you prefer? : abap bdc

717


What are the different database integrities?

581


What is view? Different types of view. Explain?

588


What is meant by authorization? Did you ever work on it? : sap abap hr

522


1)can any body tell the transport request number concept and 2)there are 3 screens in one screen u have uploaded the resume and second screen also u have done the same thing but when u are uploading the resume in third screen u got some error in somewhere else but whatever u have uploaded the resume in 1 and 2 should not

1653


hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display

2556


What are field symbols?

640


How can cluster table be created?

656