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
- 10670 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
Difference between sy-tabix and sy-index? Where it is used?
What is an evaluation path? : sap abap hr
Explain the uses of the simple maintenance interface? : sap abap hr
What is the difference between pnp and pnpce? : abap hr
What is lock mechanism? How do we create lock objects in abap?
Proxy Programming with ABAP - How to develop the Proxy identification through programming
What is the purpose of sum statement?
What is a table attribute?
the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....
What is difference between inner join and outer join?
What’s value table?
How do you backup Sapscript layout sets? Can you download and upload? How?
Tell me a scenario where did you use secondary index?
What is pass by value and what is pass by reference? Which is better?
Explain how many types of tables exist and what are they in data dictionary?
