Archives of the TeradataForum

Message Posted: Fri, 01 Jun 2012 @ 21:05:43 GMT

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

And look at the plan. If you are doing a join on a nullable field, the optimizer will qualify out the rows with nulls when they cannot contribute to the result.

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