Read this great (and old) article --> http://www.oraclemagician.com/mag/magic8.pdf about MINUS vs NOT EXISTS operators.
There really isn’t just one right way to design queries. In some cases, you really are better off using Not Exists. In many cases, however, you should use the set operator MINUS. Once you understand the principles, you can easily choose the best method for your particular case.
No comments:
Post a Comment