An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.
Please be aware that you'll need to have the Adobe Flash Player 9 Plug-in installed to watch this video.
Runtime: 3:00 minutes
These videos are provided by JumpstartTV and End to End Training