我有一张数据表 TNest (AccessName,PlanName,KeyWord,Show,Hitcount,Consumer,ClickRate,AvgPrice);现要统计该表数据,语法如下:
SELECT AccountName, PlanName, KeyWord, SUM(Show) AS Show,
SUM(Hitcount) AS Hitcount,SUM(Consumer) AS Consumer,
ROUND(AVG(ClickRate), 4) AS ClickRate , ROUND(AVG(AvgPrice), 2) AS AvgPrice
FROM TNest GROUP BY AccountName, PlanName, KeyWord
有什么办法能加快这个统计的速度呢???这里面的字段均已加了索引!!
在线等,急求!!!