• Indexed views have some stringent requirements on what kind of view definition they can be created on. Derived tables are not allowed.

    Have a look here for a complete list of what's not allowed:

    http://msdn.microsoft.com/en-us/library/ms191432.aspx#Restrictions