索引视图可以提高性能

SETSTATISTICSTIMEON

SELECT MemberProvince,
        MemberCity,
        COUNT(1)AS数量
FROM   member.memberbaseinfo
GROUPBYMemberProvince,
        MemberCity
SET STATISTICSTIMEOFF
--DROP VIEW vv
CREATEVIEWvv
WITH SCHEMABINDING
AS
    SELECT MemberProvince,
            MemberCity

,
            COUNT_BIG(*)AS数量
    FROM   member.memberbaseinfo
    GROUPBYMemberProvince,
            MemberCity


CREATEUNIQUECLUSTEREDINDEXIDX_V1
ON vv(MemberProvince,MemberCity);
   
SET STATISTICSTIMEON

SELECT MemberProvince,
        MemberCity,
        COUNT

(1)AS数量
FROM   member.memberbaseinfo
GROUPBYMemberProvince,
        MemberCity

性能有大幅提升