indexed-views

Does Indexing a View in Sql Server 2008 actually duplicate the original data?

Hi folks, If i create an Indexed View (in Sql Server 2008), does this mean i copy all required the data from the source tables into a separate new table? Or are only some tiny pointers/indexes saved, to represent this view? ...

How to create materialized views in SQL Server ?

I am going to design a DW and I heard about materialized views. Actually I want to create a view and it should update automatically when base tables are changed. Can anyone explain with an query example.. ...