SQL优化典型案例分析详细分解.doc

关键字：充分利用过滤条件 原始sql查询 SELECT DISTINCT AS rowid, AS id, a.cstguid, b.cstname, Isnull(b.cardid,) AS cardid, Isnull(b.mobiletel,) + + Isnull(b.hometel,) + + Isnull(b.officetel,) AS lxtel, AS oppguid, a.buguid, AS projguid, c.memlevel, c.memcode, c.memguid, c.buguid AS hjbuguid, AS username, AS userguid, d.buname AS hjbuname FROM p_cstattach a