Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 5240 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / 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 |
Can the administrator easily maintain and manage microstrategy intelligence server?
Explain rw document?
Can a record be inserted and updated in database using microstartegy?
What do you mean by staging area?
You have got the requirement from a client. Explain the technical approach you will take now.
What is dynamic aggregation in microstrategy?
What do you mean by dimensional modeling and relational modeling?
what is subqueary and what is temporary tables?
What are the vldb properties? Which level of vldb configurations have the highest precedence?
What is adaptive metric?
What are the different modes to run i-server?
How do you ensure simultaneous releases across multiple operating systems?
Teradata 
