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
- 11700 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 logical databases : abap hr
What will happen when we use fully buffered in abap?
What are the fields in the memory table ‘screen’?
What kind of deliverables you have on a day to day basis?
To find the date difference & excude saturday & sunday in between them
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?
What are the events driven batch jobs?
What are control tables?
What are the aggregate objects in the data dictionary? : abap data dictionary
How we can give authorization on the fields of table control in a dialog-programming?
Hello All, Requesting to all user of this site. Please post your Questions in Proper sub Category of chosen category. Some users post the questions in common category whether sub category for that is available ..like some users still post the SAP Script & ALE Related questions in common ABAP Category. Due to this it becomes very difficult to find the topic wise Questions. Please cooperate with the site & to other users. Thanks & Regards Tamseel
What is the significance of technical settings (specified while creating a table in the data dictionary) ?
How to know if the value entered contains records or not?
What are client dependant objects in abap/sap?
Define external layer?
