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
- 13532 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
when do you need to create an internal table with header line ? and with out a header line?
How can a lock object be called in the transaction?
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
What are the differences between transparent tables, pooled tables & cluster tables? : abap data dictionary
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/
Explain about Recording Function?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?
What is the use of the raising exception? : abap modularization
What is meant by authorization? Did you ever work on it? : sap abap hr
What is modularization and its benefits?
What is buffering allowed but switched off?
What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?
What are the attributes of a field that can be activated or deactivated during runtime?
Can matchcode object contain ids with different update types? : abap data dictionary
What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary
