SAP
C_HANAIMP_12 · Question #137
What performance techniques should you implement to improve join per-formance? There are 3 correct answers to this question. Response:
The correct answer is A. Use unions instead of joins for combining large data sets. B. Always specify the cardinality of a join. D. Use left outer joins instead of right outer joins. See the full explanation below for the reasoning.
Question
What performance techniques should you implement to improve join per-formance? There are 3 correct answers to this question. Response:
Options
- AUse unions instead of joins for combining large data sets.
- BAlways specify the cardinality of a join.
- CJoin as many tables as possible in an analytic view's data foundation.
- DUse left outer joins instead of right outer joins.
- EAlways mark joins as dynamic to improve performance.
How the community answered
(61 responses)- A70% (43)
- C20% (12)
- E10% (6)
Community Discussion
No community discussion yet for this question.