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 / 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 are the disadvantages of logical databases?
What is the difference between Check and Continue?
What is the definition of modification in an sap system and how do they impact an upgrade?
Explain what are the events used for logical database?
What are the page windows?
what will happen if called program is not executable ?
What are the different abap editors? What is the used of different editors in abap?
Explain the use of insert and append statement in sap abap?
How many types of size categories and data classes are there? : abap data dictionary
What are different data types in abap/4?
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
What is an abap/4 query? : abap hr
how to see the table output?
Where the payroll results are stored
What is the abap program name to process the batch input session automatically? : abap bdc