Answer Posted / praveen
For performance tuning
1)it is done with the help of VLDB properties
2)check the intermediate sql passes and try to reduce the passes
3)apply filter conditions where ever required.
4)No cross join to be happened
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?
Explain object variable error?
What are the different types of metrics available in microstrategy?
What are the types of facts in microstrategy?
Explain level extension?
Difference between project merge and object manager?
What subtotaling features does microstrategy desktop contain?
At which levels you can set the vldb properties? Which level has the highest pecedence?
What do you mean by dimensional modeling and relational modeling?
Explain fact structure?
Explain microstrategy logical primary keys?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
Explain snowflake schema?
Explain oject manager?
Is there a difference between view filter and report filter?