这个查询太慢了。可以优化吗?
SELECT
CONVERT(CHAR(10), MAX(dat), 101) AS MaxDate
FROM
X_Prices price
INNER JOIN
RMetal cat ON cat.SubCat = price.Subcat AND cat.Category = price.Category
WHERE
cat.Country = 'India'
AND cat.Section = 1
AND cat.active = 1
AND cat.inactive = 0
AND price.Dat < GETDATE() - 60
对于此查询:
SELECT CONVERT(CHAR(10), MAX(dat), 101) AS MaxDate
FROM X_Prices price INNER JOIN
RMetal cat
ON cat.SubCat = price.Subcat AND cat.Category = price.Category
WHERE cat.Country = 'India' AND
cat.Section = 1 AND
cat.active = 1 AND
cat.inactive = 0 AND
price.Dat < GETDATE()- 60 ;
我会在索引开始RMetal(Country, Section, Active, Inactive, Category, SubCat)
和X_Prices(Category, SubCat, date)
。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句