This is discussed very well in the SQL Server BOL. Check out the topic Creating an Indexed View.

The requirements for creating an Indexed View are pretty tough.

-Mike


>Hi All:
> I have two questions:
> (1). How can I create an index on a view?
> (2). How can I create a noncluster index?
>Thaks
>MA