Archives of the TeradataForum

Message Posted: Tue, 23 Feb 2010 @ 14:47:02 GMT

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

Dieter is right - use explain to find out. Also, 'usually' negative logic will cause FTS as you are really asking for everything that is NOT in/= and an FTS will work faster. Also, for a PI there is no secondary index to use anyway!

JK Wight
EDW - Integration/DBA
Swift Transportation Corp.

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