sql server视图优化
CREATE VIEW MMS_TOTAL_CHARGES AS
SELECT
A.EA_ANO AS EA_BRID,
SUM(A.EA_JE) AS TOTAL_CHARGES
FROM (SELECT EA_ANO,EA_JE FROM EA_AMXFY WITH(NOLOCK) WHERE EA_JZSH IS NULL
UNION ALL
SELECT EA_ANO,EA_JE FROM EA_ZYYPMXK WITH(NOLOCK) WHERE EA_JZSH IS NULL
UNION ALL
SELECT EA_ANO,EA_JE FROM EA_ZYYJMXK WITH(NOLOCK) WHERE EA_JZSH IS NULL) A
GROUP BY A.EA_ANO
EA_AMXFY,EA_ZYYPMXK,EA_ZYYJMXK ,这三张表是消费金额表,每个人在这三种表中可能有多条消费记录,
EA_ANO是这个人的标示,EA_JZSH表示这个人的状态。现在求EA_JZSH状态为空时,这人的总消费是多少。
求优化一下这个查询速度怎么来弄,在线等。