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 |