在SQL Server中使用索引视图查看性能改善

CREATE TABLE SalesHistory

(      
      SaleID INT IDENTITY(1,1),            
      Product VARCHAR(30),       
      SaleDate SMALLDATETIME,       
      SalePrice MONEY

)



DECLARE @i SMALLINT

SET @i = 1



WHILE (@i <=10000)



BEGIN      
      INSERT INTO SalesHistory      
      (Product, SaleDate, SalePrice)      
      VALUES      
      ('Computer', DATEADD(mm, @i, '3/10/2006'), DATEPART(ms, GETDATE()) + (@i + 57) )


      INSERT INTO SalesHistory      
      (Product, SaleDate, SalePrice)      
      VALUES      
      ('BigScreen', DATEADD(mm, @i, '3/2/2006'), DATEPART(ms, GETDATE()) + (@i + 13) )


      INSERT INTO SalesHistory      
      (Product, SaleDate, SalePrice)      
      VALUES      
      ('PoolTable', DATEADD(mm, @i, '2/11/2007'), DATEPART(ms, GETDATE()) + (@i + 29) )


      SET @i = @i + 1



END

GO