Archives of the TeradataForum

Message Posted: Fri, 21 Jun 2013 @ 11:41:43 GMT

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

Hi,

Use EXISTS or JOIN. It will be faster.

If there are more values are coming as result of subquery, IN will work slower.

Thanks,

Sughesh.

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