Re: IN vs NOT IN
From: Steven Findlay <findlays_at_unbc.ca>
Date: Thu, 07 Dec 2000 10:29:12 -0800
Message-ID: <3A2FD6F8.5060801_at_unbc.ca>
Date: Thu, 07 Dec 2000 10:29:12 -0800
Message-ID: <3A2FD6F8.5060801_at_unbc.ca>
The NOT In requires a full table scan well the IN clause can use the index that is associated with the column you are processing against... Received on Thu Dec 07 2000 - 19:29:12 CET