Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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 an i-server?

988


what are logical views used for?

947


What is adaptive metric?

887


differentiate between two-tier, three-tier and four-tier connections.

926


Explain adhoc reports?

866


What does microstrategy desktop allow users to do?

852


Name the types of transformation?

887


Explain level extension?

957


How do users receive only information that they want?

919


What subtotaling features does microstrategy desktop contain?

924


What is pass through metrics in microstrategy?

883


Can a record be inserted and updated in database using microstartegy?

880


Explain heterogeneous mapping?

896


To save time, can many reports be run at the same time?

970


What is an object prompt?

965