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...

How to do performance tuning on reports.

Answer Posted / sunil

For performance tuning there some areas where you need to look and work accordingly.

like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)

its better if go go in the same order....

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by derived metrics?

928


What according to you are the roles and responsibilities of a microstrategy developer?.

949


What are vldb properties in microstrategy?

944


Explain absolute filter?

902


Explain two-tier connection?

888


What are the tracing options available in microstrategy object manager?

906


Explain fact degradation?

944


how do you create schema objects in 2 tier connection?

881


Your application mode has crashed. How would you get the instance back?

867


What are objects?

941


According to you, what are the most important tables in a dw? Why?

912


Explain 4gt switch. Does it have any drawback?

918


What is an object prompt?

969


Explain four-tier connection?

853


What is smart metric?

914