Add Unique Index on Union View (SQL Server 2008)

I have a view which combines two tables using UNION ALL.

Is it possible to 开发者_如何学JAVAcreate a unique index on the view?

No, you cannot create an indexed view if the view is using UNION, this was true in SQL 2000 and is still true in 2008, see also http://msdn.microsoft.com/en-us/library/dd171921(SQL.100).aspx

Indexed views cannot contain the UNION operator: see here