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
Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?
What is a development class? : abap data dictionary
What are the different message types available in the abap/4 ?
What are types of select statements?
What is the function of the transport system and workbench organizer?
What are the function module in bdc?
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization
What are screen painter and menu painter? : abap hr
Which infotype records can not be deleted ? : abap hr
What is a transport?
Explain the different types of view?
Which bdc you prefer? : abap bdc
Explain what is step-loop?
What are uses of foreign key?
How to call a subroutine in sapscript?