2> CREATE VIEW v WITH SCHEMABINDING AS
3> SELECT a, SUM(b) AS sum_b, COUNT_BIG(*) AS c
4> FROM dbo.t
5> GROUP BY a
6> GO
1> CREATE UNIQUE CLUSTERED INDEX idx ON v(a)
2> GO
1> set showplan_text on
2> go
1> Select * from v where a = 2
2> go
StmtText
------------------------------
select * from v where a = 2

(1 rows affected)
StmtText


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------
  |--Stream Aggregate(DEFINE: ([Expr1004]=SUM([staging].[dbo].[v].[sum_b]), [Expr
1005]=SUM([staging].[dbo].[v].[c]), [staging].[dbo].[t].[a]=ANY([staging].[dbo].
[v].[a])))
       |--Clustered Index Seek(OBJECT: ([staging].[dbo].[v].[idx]), SEEK: ([stagin
g].[dbo].[v].[a]=(2)) ORDERED FORWARD)


(2 rows affected)

 SELECT * 
   FROM v

 SELECT * 
   FROM v
  WHERE A = 2