By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

update versus rebuild

P: n/a
SG
Hi,
Is there ever a case where a total rebuilt is preferable to an
update? I am talking in the context of a data warehouse.

Many thanks
Sam
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ray
Certainly, when a warehouse is designed to only contain a representation of
wha'ts in the sources at the extraction time or history is maintained as
point in time copies (month ends is a typical example)

Under these conditons, many times a truncate and bulk copy process is faster
than an incremental update. However, this technique will lose ground time
wise as data grows where an incremental process generally doesn't grow much.

Ray

"SG" <sg*****@yahoo.ie> wrote in message
news:fe**************************@posting.google.c om...
Hi,
Is there ever a case where a total rebuilt is preferable to an
update? I am talking in the context of a data warehouse.

Many thanks
Sam

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.