先建立索引 改为试试 SELECT * FROM (SELECT temp .*, SUM(unnum) FROM KCT_CPB temp WHERE (MerID = 'sykh001') AND (ProID = 'GZ1#') AND (sumbool = 24.21) AND (unnum > 0)) DERIVEDTBL WHERE (sumNUM < 770)
实在慢的话,试试这样: select * into # from kct_cpb where proid='GZ1#' 再在#表上做你的统计.
改为试试
SELECT *
FROM (SELECT temp .*, SUM(unnum)
FROM KCT_CPB temp
WHERE (MerID = 'sykh001') AND (ProID = 'GZ1#') AND
(sumbool = 24.21) AND (unnum > 0)) DERIVEDTBL
WHERE (sumNUM < 770)
select * into # from kct_cpb where proid='GZ1#'
再在#表上做你的统计.