See performance gains by using indexed ... In fact, a view really doesn’t do anything until you query it. In SQL Server 2000 and 2005, you have the ability to add indexes to views.

I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on random rows it will die with this error:<BR ...

SQL Server 2012 includes a lot of new and ... They cannot be created as filtered index, placed on computed or sparse columns, multiple columns at once, or on an indexed view. Columnstore indexes are ...