SEO

#1 (**permalink**) 02-29-2008, 05:32 AM

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

#2 (**permalink**) 02-29-2008, 05:32 AM

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" <sgpgpjr@yahoo.ie> wrote in message
news:fe3ac5dd.0501110346.70e3325b@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

update versus rebuild