Archives of the TeradataForum
Message Posted: Tue, 21 Jul 2004 @ 00:57:40 GMT
You can probably see why if you get explains and examine them carefully. Both NOT IN and NOT EXISTS will trigger an exclusion join. Are any of the columns involved nullable? If so, it will probably make NOT IN run slower.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|