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 is get cursor field?
Badi concepts
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
What is the syntax for call transaction? : abap bdc
Explain the structure of a bdc sessions?
What is locking ?
If yes then why do we require logical database
What is a report?
how 2 create the normal form by using functional module
Explain the advantages and disadvantages of abap query tool?
How to create any functions? How to go about it?
What is a batch input session? : abap hr
Explain the use of insert and append statement in sap abap?
What are the commands used for interactive reports?
What are the page headers for secondary lists?