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 / prats
For Key Field Inner Join is most appropriate if all keys
are matched. For example: EKKO-EKPO based on EBELN. It
reduces the network traffic for selecting data from both
the tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is internal payroll process? : sap abap hr
What are the differences between session method and call transaction method? : abap bdc
What is the table & field to identify the no of items (bottles) stored in one case?
List the events in abap/4 language?
what are the two methods of modifying sap standard tables ?
Control Break statements- At new...endat.
Which transaction code can I used to analyze the performance of ABAP program.?
What is the diffreence between bdc_close_group and bdc_close_dataset? : abap bdc
How can we create callable modules of program code within one abap/4 program? : abap modularization
How can we access the correction and transport system? : abap data dictionary
How many types of buffering? : abap data dictionary
What is the differences between abap and ooabap. In which situation we useooabap?
What is your current client number?
What is an evaluation path? : sap abap hr
In select-options, how to get the default values as current month first date and last date by default?