Archives of the TeradataForum
Message Posted: Thu, 23 Apr 2015 @ 12:48:37 GMT
If the explain plans are the same then performance will be the same.
Where have you read or in what context have you been told that "not in" should be avoided in queries? The most obvious / common place where there might be an issue with "not in" is when using a sub-query that may return a NULL 'row'. In this case you will always get 0 rows back from the query. (And if you are seeing the "AND" and "NOT IN" queries generating the same explain plan then I think it unlikely that you are using a sub-query).
Whether the plan shows an FTS or indexed access to a table is probably nothing to do with NOT IN or multiple AND'd conditions.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|