Archives of the TeradataForum

Message Posted: Thu, 20 Nov 2008 @ 15:30:45 GMT


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

Subj:		Re: Something like an 'IN' keyword between

From:		Geoffrey Rommel

          > >  where SOCIAL_SECURITY NOT = '103-183-336'

I have found in Teradata it is better to do this:

          >  where NOT SOCIAL_SECURITY = '103-183-336'

Really?? I would report this. Seems like a design flaw in the optimizer.


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

Archives

2008 Indexes

Last Modified: 15 Jun 2023