dbTalk Databases Forums  

ROLAP Partitions - Aggregations - availability of data

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


Discuss ROLAP Partitions - Aggregations - availability of data in the microsoft.public.sqlserver.olap forum.



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

Default ROLAP Partitions - Aggregations - availability of data - 01-07-2004 , 04:31 AM






Short questions
ROLAP Partition - no realtimeupdates - Indexed views as aggregations
- wenn become the new data vailable if i insert new rows in the facttable ?
- is there the need to reprocess the partition to drop the cached values ?
- and why drops and recreate and data refreh aggregations in indexed views
(sql server do all the changes at the insert [costs time] and then as2k
drops and recreates the view [costs much more time]) ?

Thanks
Hannes



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.