CREATE UNIQUE CLUSTERED INDEX on VIEW

[baran121]

Hello i have a problem about creating index on view.


CREATE UNIQUE CLUSTERED INDEX IDX_vw_vhesap ON dbarge.dbo.vw_vhesap (pers_num,bant_num,tarih,saat,mesai)

i tried this for UNIQUE CLUSTERED INDEX index

i got this error message :

Cannot index the view 'dbarge.dbo.vw_vhesap'. It contains one or more disallowed constructs.

i didnt understand what is the problem.
please help me.

 

[markros]

Does your view confirm to everything in this page

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

?

PluralSight Learning Library