Archives of the TeradataForum
Message Posted: Thu, 30 Jan 2003 @ 05:09:31 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|