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
- 13146 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ravi gupta
inner join is more efficient
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What are pool tables?
Hi, I have a requirement for locking the fax field in user master records. As you know user can edit the details using the System>profile>own data (SU3), it is causing some security threat to our model. What i want is users should not be able to change the fax field under communications when they get into su3.I have heard of user Exist functionality but don't know how to implement it. Can you suggest something, it will be greatly appreciated.
Explain what are extracts?
What is the difference between a dialog program and a report?
What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary
What are differences between at selection-screen and at selection-screen output?
Explain what is the difference between sy-tabix and sy-index? Where it is used?
How table control cn be generated using bdc? : abap bdc
what is mean be On Change of in Control Break statement
In which time constraint does the infotype records depend on the subtype ? : abap hr
What is lock object ? : abap data dictionary
What are the events driven batch jobs?
How will you read from internal table records in a given value range (without using loop)
What are interface/conversion programs in SAP?
How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?
