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
- 13285 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
THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM
What are indexes? : sap abap data dictionary
What are the function modules used to create batch input session? : abap bdc
Explain the advantage of structures?
how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul
What are datasets in abap?
What’s value table?
Can you define a field without a data element?
What is the difference between refresh and free statements?
What are the relational operations that can be performed on view in sap? : abap data dictionary
Did you use buffering?
Can a constructor be redefined?
hi.. sap sd is installed in my PC .i m unable to start becoz ,i have given wrong password many times and it's locked.please tell me how can i open SAP logon. tell the process at my id dst.noida@rediffmail.com please advance thanx
Create any functions? How to go about it?
Explain what is step-loop? Explain all the steps?
