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
- 10730 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amit pradhan
For Key Field Inner Join is most appropriate on the non-key
field for all entries is best
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between transparent tables, cluster tables and pooled tables
What are the features of abap/4 dictionary? : abap data dictionary
What are the advantages of abap query tool?
How are the date abd time field values stored in sap?
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
How to give programe name as input in BDC report of abap ?
Explain different types of attributes of function module?
What is the difference between collect and sum?
How does the interection between the dynpro and the abap/4 modules takes place?
Why do we use types statement in abap programming?
What is the difference between function group and function module?
What is cts and what do you know about it? : abap hr
What is an update type with reference to a match code id?
What are the basic objects of the data dictionary?
What are the payroll related Infotypes
