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
- 13522 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
Explain what are the different functions used in sap script?
How to debug a sapscript?
Explain the Inportance of pa30? : abap hr
What are the data types of the external layer? : abap data dictionary
What is an interactive report? What is the obvious difference of such report compared with classical type reports?
Can i Have Some Realtime Examples on Badi ?
What are the ways you can do the tuning?
What happens if only one of the commands set screen and leave screen is used without using the other?
What is a predefined type in abap?
How to display or know if the value entered contains records or not?
Explain what are extracts?
How will you link form with the event driven in sap scripts?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
What are the parameters in bdc_insert? : abap bdc
How to load data from ms excel sheet to sap by using bdc method ? : abap bdc
