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
- 13794 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
How to add a column to a table control while using alphanumerical layout editor ?
In sap scripts, how will you link form with the event driven?
What are the problems in processing batch input sessions?
What are the functional areas, user groups? How does abap query work in relation to these?
Write special commands of list?
What is the difference between refresh and free statements?
What’s value table?
what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
When, how and how would you control changes to standard SAP objects.
In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?
Why are insert and append statement used in sap abap?
Explain about interactive report?
In a loop of an internal table, what is the use of at first & at last statements?
What is your approach for writing a bdc program? : abap bdc
