View Single Post
  #5  
Old 8th September 2006, 09:03
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
IN/NOT IN vs AND/OR

The usage of an IN/NOT IN should result in the same data approach as an AND/OR. As the writing of an IN/NOT IN is sometimes easier to show the logic of a query, I mostly prefer this one.

So, for performance it should not matter. Maybe there are exceptions, but I don't know them yet.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote