NOT EXISTS and NOT Operator - 07-19-2012 , 08:36 AM
Can someone please help me on the below doubts in Oracle 8.1.7 :
1. How does NOT EXISTS and NOT Operator work in the below query. Its confusing, please explain me the functionality over here in detail?
2. since not exists is not recommended to be used and not operator too. please suggest me the list of methods that this query can be re-written to improve the query performance!!??
from table2 t1
where t1.col2 = 'X'
and not exists
from table2 t2
t2.col3 <> 'Y'
and t1.col1 = t2.col1
Thanks in Advance.
Re: NOT EXISTS and NOT Operator - 07-19-2012 , 10:59 AM
On Jul 19, 6:36*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Who says it is not recommended?
@home.com is bogus.
There are legs in the tape market yet. http://www.theregister.co.uk/2012/07/19/oracle_sl150/
Re: NOT EXISTS and NOT Operator - 07-20-2012 , 11:34 AM
joel garry wrote: