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
- 13144 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 different types of mode (run code) in call transaction method?
Explain about sap fico testing and the tools used? : abap bdc
What are logical data bases used in hr module? : abap hr
What is maintenance view?
What is meant by authorization? Did you ever work on it? : sap abap hr
Select query optimisation
What is the use of a pretty printer?
What is structure?
What is difference between inner join and outer join?
What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr
What is the t-code to display batch input sessions? : abap bdc
What are the Various Types of internal tables?
What is lock mechanism? How do we create lock objects in abap?
What is the table buffer? Which type of tables used this buffer?
Can matchcode object contain ids with different update types? : abap data dictionary
