通过 SQL Server 2005 索引视图提高性能(8)

WHERE a <> 0 GO CREATE UNIQUE CLUSTERED INDEX IV on View7(a) GO -- legal: INSERT INTO T VALUES(1) INSERT INTO T VALUES(2) INSERT INTO T VALUES(0) INSERT INTO T VALUES(0) -- duplicate 0   -- dissalowed: INSERT INTO T VALUES(2)