materialized view vs. denormalized table

From: ChrisR (anonymous_at_discussions.microsoft.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 12:37:59 -0700

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

Relevant Pages

  • Re: materialized view vs. denormalized table
    ... no you would not have to repopulate ... "ChrisR" wrote in message ... > Dont you need to update/ repopulate them both if data in ... > the underlying table changes? ...
    (microsoft.public.sqlserver.server)
  • Re: CONGRESS ONCE AGAIN CHEATS HINDUS !!!!!!
    ... and when did you become 'citizen' of Mumbai? ... to worry for whats happening in maharashtr cabinate expansion? ... linguistic minority dont poke #$% into maharashtr. ... the forces against this are minority appeasers and communists. ...
    (soc.culture.indian)
  • Re: Mindless dodo.
    ... could fit with his image of whats is valid to post in the colosseum. ... You either have free speach or you dont. ... As long a people cant stand free speech, war will allways ... is a bright smiling star, and the next time you met her, she is a troll. ...
    (alt.lang.asm)
  • Re: Rider Doon
    ... I rang the bloke who was the only witness to see the speeding cars today. ... He replied I dont want you to use my name I dont want to be involved. ... A non fault accident and ive got nowhere to go, whats the world coming to when someone just decides they dotn want to go through the hassle of a possible interview? ...
    (uk.rec.motorcycles)
  • Re: TDI TUNING
    ... > so far its a chip supposedly giving 140 bhp and 310nm torque but beyond ... > this i dont know where to look, whats the best approach to freeing up some ...
    (uk.rec.cars.modifications)