Skip to Content
Former Member
Sep 08, 2005 at 09:00 PM

Cube compression and DB Statistics



I am going to run Cube compressions on a number of my cubes and was wondering few facts about DB Statistics. Like:

1) How does the % of Info Cube space used for DB stats helps. I know that the more % we use the bigger is the stat and faster is the access but stats run longer. But would increasing the default value of 10% make any difference or overall performance improvements.

2) I will compress the cubes on a weekly basis and most of them will have around one request per day so will probably compress 7 requests for each cube. So it is advisable to run stats also on a weekly basis or can it be run on bi-weekly or monthly basis? and what factors does it depend on?

Thanks. I think we can have a good discussion on these apart from points.