Archives of the TeradataForum

Message Posted: Thu, 01 Aug 2002 @ 13:35:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Personally I have always found NOT EXISTS processing to be slow and have tended to make use of LEFT OUTER JOINS.

Therefore your query would look something like

SELECT colA
FROM small_table T1
  LEFT OUTER JOIN big_table T2
    ON (T1.colA = T2.colA)
WHERE T2.colA IS NULL
GROUP BY 1

Regards

Matthew Winter

Technical Architect
TPG IS Design Authority
Teradata Certified Professional

	<Prev	Next>		<<First	<Prev	Next>	Last>>