Re:Learn SQL, dammit
by daigoba66 on Wednesday May 08, 2013 @03:36PM
(#5676353)
Depending on the query and the optimizer, the resulting plan for IN/NOT IN might be the same as EXISTS/NOT EXISTS. E.g. a left semi join. I know this is true for MSSQL Server, I can't speak for Oracle.
[ Parent
| on HN ]
There are no comments on this comment yet.