This is from the Books Online documentation that comes
with SQL Server 2000:
From the article "create index"
The view must be defined with SCHEMABINDING in order to create an
index on it.
There are other requirements for a view to be indexed in the same article.
Also, you cannot create a nonclustered index only on a view. A requirement
for creating a nonclustered index on the view is that a clustered index
>I have a view based on another View and this completes
>extraction information of two tables....
>CREATE UNIQUE NONCLUSTERED INDEX P_Rirsa
>ON Tops (Customerid, OrderId)
>at the time of creating index in the last View marks the
>following error to me:
>Server: Msg 1939, Level 16, State 1, Line 1
>Cannot create index on view 'TopS' because the view is not
>Somebody has the idea of like solving it