Re: Optimizing a UNION Query

[Toa Sty]

Just thinking about it a bit more, you don't need to use subselects for this really.


Does this do what you want? Is it faster?

SELECT DISTINCT d1.docid FROM glossary g1, docref d1, glossary g2, docref d2, docIndex di
WHERE
g1.termid=d1.termid AND g1.word IN ('apple','orange','banana')
AND
g2.termid=d2.termid AND g2.word IN ('red','blue','green')
AND
d1.docid = di.docid AND d2.docid = di.docid;