Archives of the TeradataForum

Message Posted: Tue, 21 Jul 2004 @ 00:57:40 GMT

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

You can probably see why if you get explains and examine them carefully. Both NOT IN and NOT EXISTS will trigger an exclusion join. Are any of the columns involved nullable? If so, it will probably make NOT IN run slower.

Jon

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