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
- 13518 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / joydip
One Single Inner join between database tables is much
faster than multiple For all entries.Also we may have to
create more internal tables in ABAP code to avoid one inner
join, which is not referable.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the tcode to create indexes?
How to write a code for multiple transactions? : abap bdc
How to determine the attributes of an internal table?
Is it possible to bring select option in module pool screens?
What is modularization and its benefits?
What is match code? : sap abap hr
What work you have done in HR module
What do you mean by transparent tables in sap abap? : abap data dictionary
How many detail lists can be created in interactive reporting?
how do you transport lsmw data from one system to another?
In the MM module for finding out the standard cost what is the view one has to look at?
What is lock object ? : abap data dictionary
How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.
Does the table can have multiple foreign keys?
How would you set the formatting options statically and dynamically within a report?
