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

CREATE VIEW vw_salesbyproduct

AS

SELECT

Product,

COUNT_BIG(*) as ProductCount,

SuM(SalePrice) as TotalSales

FROMdbo.SalesHistory

GROUP BY Product