dbTalk Databases Forums  

Partitions on one or multiple fact tables?

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


Discuss Partitions on one or multiple fact tables? in the microsoft.public.sqlserver.olap forum.



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

Default Partitions on one or multiple fact tables? - 06-05-2004 , 11:11 PM






I want to create a cube with partitions on current (1 day) and history (1 month) data. The current day partition needs to be updated intraday by data push. For performance, should I use one fact table with filters on the two partitions or use two separate fact tables? Thanks!

Reply With Quote
  #2  
Old   
pryly
 
Posts: n/a

Default RE: Partitions on one or multiple fact tables? - 06-06-2004 , 06:16 PM






It doesn't make any difference in terms of run-time performance if you build MOLAP. regarding processing time
you need to build index on the filter column if you choose to use one fact table, otherwise, the processing time may suffer.

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.