Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 9 Answers
- 13271 Views
- IBM, I also Faced
- E-Mail Answers
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
How to find the return code of a statement in abap programs?
What is the project you are currently working and work that you are doing
Does the external program run in the same sap luw as the caller, or in a separate one?
The data of a view is not physically stored, but derived from one or more tables (t/f) : abap data dictionary
Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc
What are internal tables? How to use a specific number occurs statement?
How do you read files from the presentation server ? : abap bdc
What are the three hierarchical levels of data types and objects?
Explain the use of insert and append statement in sap abap?
How the at-user command serves mainly in lists?
Which FM do you use to find out who is reporting to whom
What is the significance of delivery class?
Explain the disadvantages of abap query tool?
How we format the data before before write statement in report ?
How to insert a line into abap internal tables?
