这样的SQL语句优化,占用cpu比较高,表有30万条记录
1.当拥有几千人查询,cpu占用100%
cpu Reads
2297 56382
select 表.字段 from BusinessChance,MemberInfo,AutoSite where BusinessChance.MemberInfoID=MemberInfo.id and MemberInfo.AutoSiteID=AutoSite.id and BusinessChance.ddlTypeID = '供应商机' and BusinessChance.txtTitle like '%电脑%'
2.当返回 count(id)时
cpu Reads
828 30767
cpu占用比较高,不知如何是好! 感谢!!!