A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
Answer Posted / balav
First make sure you,
1. Check for the Backend loads being run on the time of report execution.That might also impact the report execution time.
2. But in future to avoid this long run, you can check the SQL global optimization setting of VLDB properties.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Define different types of attributes in microstrategy desktop?
what is the difference between microstrategy and cognos?
how do you create schema objects in 2 tier connection?
What are the benefits of using microstrategy intelligence server?
What is heterogeneous mapping?
What is microstrategy desktop?
How do users receive only information that they want?
Explain three-tier connection?
What are vldb properties in microstrategy?
What are prompted filters? Have you ever used them? Where?
Explain 4gt switch?
How would you configure wh authentication?
Can microstrategy desktop access sap data?
What are report filters and view filters?
What are logical views used for in microstrategy?