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
- 10612 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kiran reddy
If we are going to join 2 to 3 data base tables Inner join is the best one but when you are going to join more then 3 tables for all entries is the best method because it will reduce load on the data base.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define the various contents of technical specifications ?
Give few names of pooled tables in sap ?
Which type of tables used this buffer?
What is a bsp application? : sap abap hr
Explain the disadvantages of logical databases?
What is a predefined type in abap?
Example of table cluster and cluster tables.
What are the data classes in abap?
What is the collect statement?
In SAP Script,How to display a single field(like matnr)at the right end of the form.
What are different data types in abap/4?
What are the names of the function modules that will be generated upon activation of a lock object?
What are data classes? What are the various data classes available for selection? : abap data dictionary
How did you test the form you developed? How did you taken print?
What is dynpro? what are its components ?
