Query running very slow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any suggestions on how to speed up this query? As it is, it take about 3-5
minutes to run.

SELECT MissingByColumn.tag, MissingByColumn.Fix
FROM MissingByColumn LEFT JOIN [Define Columns] ON MissingByColumn.Fix =
[Define Columns].Fix
WHERE (((MissingByColumn.tag)=[Enter the tag you want to check]) AND
(([Define Columns].os) Like "Windows 2000") AND ((MissingByColumn.missing) Is
Not Null));
 
I suspect the problem might be with the query that this one references,
MissingByColumn. The SQL for that is:
SELECT TagFixCombinations.os, TagFixCombinations.type,
TagFixCombinations.tag, TagFixCombinations.Column, Max(IIf([Selected Fixes
Installed]!tag Is Null,1,Null)) AS missing, TagFixCombinations.[Deploy Date],
TagFixCombinations.Comment
FROM TagFixCombinations LEFT JOIN [Selected Fixes Installed] ON
(TagFixCombinations.tag = [Selected Fixes Installed].tag) AND
(TagFixCombinations.Fix = [Selected Fixes Installed].Fix)
GROUP BY TagFixCombinations.os, TagFixCombinations.type,
TagFixCombinations.tag, TagFixCombinations.Column, TagFixCombinations.[Deploy
Date], TagFixCombinations.Comment;
 
Back
Top