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


Please Help Members By Posting Answers For Below Questions

What is metadata in microstrategy?

613


how can you direct the sql generated to use a specifc table?

507


What is a implicit attribute in microstrategy?

1120


Define different types of attributes in microstrategy desktop?

762


Explain 4gt switch?

509






Explain fact degradation?

592


What do you mean by consolidations?

559


How are microstrategy reports performance tuned?

527


What do you mean by inmon?

649


How would you configure wh authentication? Explain.

521


What is fact degradation?

562


Name the various types of filters?

560


Explain two-tier connection?

517


What happens if the owner of an object does not exist in the destination project?

519


What is a joint child?

546