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
- 13140 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 are the advantages of abap query tool?
Select query optimisation
any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.
What are the components of sapscript?
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
Does the table can have multiple foreign keys?
What are the two methods for modifying sap standard tables?
What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?
When the top-of-page event does get triggered?
How to eliminate duplicate entries in internal tables?
What are the different types of sapscript symbols?
what is call back in alv?
What is an update type with reference to a match code id? : abap data dictionary
What are the types of data types in the sap abap?
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
