All Forums Database
lijianguonew 5 posts Joined 07/14
29 Aug 2014
What's the difference between NOT IN and minus in SQL?

Hello Experts:

 

What's the difference between NOT IN and minus  in SQL? 

 

Which is better to use in SQL queries for the performance aspects?

Tags:
Raja_KT 1246 posts Joined 07/09
29 Aug 2014

Run an explain for the same functionality and same tables.  You can see the steps.
I tested and see that Minus is better than not in. 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.