Archives of the TeradataForum

Message Posted: Thu, 30 Jan 2003 @ 05:09:31 GMT

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

The Teradata optimizer in V2R5.0 will notice the 1=0 condition and will understand to return "0 rows" without executing the query. And it will be quite sophisticated in its recognition of duplicate, spurious or false conditions and will do the right things with them.

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