Answer Posted / sunil
For performance tuning there some areas where you need to look and work accordingly.
like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)
its better if go go in the same order....
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What do you mean by derived metrics?
What according to you are the roles and responsibilities of a microstrategy developer?.
What are vldb properties in microstrategy?
Explain absolute filter?
Explain two-tier connection?
What are the tracing options available in microstrategy object manager?
Explain fact degradation?
how do you create schema objects in 2 tier connection?
Your application mode has crashed. How would you get the instance back?
What are objects?
According to you, what are the most important tables in a dw? Why?
Explain 4gt switch. Does it have any drawback?
What is an object prompt?
Explain four-tier connection?
What is smart metric?