dbTalk Databases Forums  

AS2005: Importance of the rowcount in dimensions & partitions?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS2005: Importance of the rowcount in dimensions & partitions? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeje
 
Posts: n/a

Default AS2005: Importance of the rowcount in dimensions & partitions? - 07-24-2006 , 10:33 PM






Hi,

I want to know what is the impact of a good vs bad row count number in the
metadata of a database in AS2005.

how this impact the performance?
the aggregation design?
etc...

and (again) do you know if there is an option to reset and count the number
of rows in 1 dimension (or all dimensions and cube etc...)
(I have too many dimensions and attributes to do it manually)

My dev server use 10 000 customers while the production server will have 200
000 members.
so, when I deploy AS keep the 10 000 member count, which is not the right
value.
(same thing for the fact table)

Thanks.

Jerome.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.