Archives of the TeradataForum
Message Posted: Tue, 23 Feb 2010 @ 14:47:02 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|