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 / prats
For Key Field Inner Join is most appropriate if all keys
are matched. For example: EKKO-EKPO based on EBELN. It
reduces the network traffic for selecting data from both
the tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the functional modules used in sequence in bdc? : abap hr
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
MY DOMAIN IS SAP-ABAP COMPARE TO WEBDYNPRO AND CRM-TECHNICAL WHICH IS BEST?
where are the passwords for ITS stores?
Tell me a scenario where did you use secondary index?
What are ranges?
hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?
what precautions or prerequisites do you follow to update a record into database table and how
What are the types of search helps? : sap abap data dictionary
visibility section for class level and attributes level
What is the relationship existing between the various data elements? : abap data dictionary
Hi,have Good Command in SAP ABAP, ABAP WEBDYNPRO now i want to learn sap IS utilities.. can u plz suggest me is it useful r not? If not can i learn BI? Is ABAP with BI have gud future?
Why grouping of fields is required? What is the max no of modification groups for each field?
What is open sql vs native sql ?
Name some data dictionary objects?