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
- 13466 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
What are the difference between tables and structures?
Static and instance variable and method with live example. Why and when to use
What are the buffering options in abap?
What are the types of table fields in the sap abap?
Why do we use events and actions in web dynpro?
Explain how do you move on to the next screen in interactive reporting?
State the differences between database view & projection view? : abap data dictionary
if u take one worst program,in this program user write the logic is session method.in that program user can get some errors ,that errors we will see in call transaction method,how it is possible.?
How do you retrieve the data for repetitive structures ? : abap hr
What is the difference between collect and append statements?
Did you create secondary index?
Difference between top-of-page and top-of-page during at line- selection?
What is meant by stacked list?
What is sap locking?
What do you mean by pooled tables in sap abap? Also explain what do you mean by table pool? : abap data dictionary
