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
- 10614 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amit pradhan
For Key Field Inner Join is most appropriate on the non-key
field for all entries is best
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does the extract statement do in extract datasets? : abap modularization
Is it possible to run host command from SAP environment? How do you run?
What are the data types of the external layer? : abap data dictionary
SM35 transaction, How to automate BDC ?
What are critical issues you have faced in your project
How did you test the form you developed? How did you taken print?
What are extracts?
Write syntax for message error (report)?
HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?
SAP Script for Billing in which Billing document number was displayed as header, Bill Type, Bill Category, Bill Item, Cost, Base Unit of Measurement and Material number were categorically displayed for each billing document number. plz mention the detail coding Tahnks, Rahul
What is the transaction code to display the payroll results ? : abap hr
Can we use on change of between select and endselect?
What are the organizational related Infotypes
How to convert the Unit for 'Distance' (The value from one Unit to another).
where are the passwords for ITS stores?
