Re: materialized view vs. denormalized table
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 09/07/04
- Next message: Russell Fields: "Re: Transaction Backup error"
- Previous message: Russell Fields: "Re: Insert new column instead of append"
- In reply to: ChrisR: "materialized view vs. denormalized table"
- Next in thread: Rick Sawtell: "Re: materialized view vs. denormalized table"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Sep 2004 15:52:07 -0400
ChrisR,
A materialized view (i.e. Indexed View) is a denormalized table that the
system keeps up-to-date for you. So, no you would not have to repopulate
it.
Having said that, there are several rules that you have to follow to get an
Indexed View created, so you should carefully read the restrictions in the
Books Online.
Russell Fields
"ChrisR" <anonymous@discussions.microsoft.com> wrote in message
news:799d01c49512$2e6bc060$a301280a@phx.gbl...
> sql2k sp3
>
> Whats the difference between these two? Isn't a
> materialized view nothing more than a denormalized table?
> Dont you need to update/ repopulate them both if data in
> the underlying table changes?
>
>
> TIA, ChrisR
- Next message: Russell Fields: "Re: Transaction Backup error"
- Previous message: Russell Fields: "Re: Insert new column instead of append"
- In reply to: ChrisR: "materialized view vs. denormalized table"
- Next in thread: Rick Sawtell: "Re: materialized view vs. denormalized table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
