HANA Performance - Quiz
1. Aggregation and filter should be used as early as possible to reduce data amount.
a. True
b. False
2. Which of the below is better in terms of performance?
a. Normal SQL statement
b. CE Functions
3. Which is better from performance point of view?
a. SQLScript Procedure
b. Modeling Views
4. Inner join is always better than Left Outer join. Hence we should always prefer inner join instead of left outer.
a. True
b. False
4. Which of the below has huge negative impact on performance?
a. Join on calculated column
b. Inner Join
c. Mixing up SQL statement and CE functions
d. All of the above
Answer:
1. a
2. b
3. b
4. b
5. a,c
No comments:
Post a Comment