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?
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 modes in lock objects? : sap abap data dictionary
Explain the structure of a bdc sessions?
I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/
What is search help exit? : sap abap data dictionary
hi to all abap interview guys please notify this .. first if u have any doubts please go through google search or else please do debugging with some sample programs . but don't post even silly questions too. thanking you.
How to Raise a Particular Ticket in Realtime ?
What are the different types of data dictionary objects? : abap data dictionary
Differentiate between table and template ?
What is the basic difference internal tables and database tables? : abap data dictionary
What is the difference between sum and collect?
What is the syntex used to call a screen as dialog box (pop up)?
Explain data dictionary in abap?
Explain lsmw?
What is payroll driver ? : abap hr
What are conditional chain statement?