Archives of the TeradataForum
Message Posted: Fri, 01 Jun 2012 @ 21:05:43 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|