>I read in a book that by indexing a view you made the data permenant.That's correct. An Indexed view is stored in a database like a table.
>That doesn't make sense.You cannot create an index on something that doesn't exist.
>Does the indexed view refresh its data each time it is selected?No, it's updated every time underlying table is updated.
--sb--