CREATE VIEW dbo.FullPath
 WITH SCHEMABINDING
AS 
 SELECT
   PE.ID, PE.OwnerID, PE.Element, FullPath = CAST( CP.FullPath as varchar(900))
 FROM  dbo.PathElements PE  CROSS APPLY dbo.CombinePath(PE.ID)  CP

 GO

  CREATE UNIQUE CLUSTERED INDEX NIX_dbo_FullPath_FullPath On dbo.FullPath(FullPath)
 

Сообщение 10142, уровень 16, состояние 1, строка 159
Cannot create index on view "TestDB.dbo.FullPath" because it contains an APPLY. Consider not indexing the view, or removing APPLY.