Hi All,

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!!??

select
'value1', value2
from table2 t1
where t1.col2 = 'X'
and not exists
(
select null
from table2 t2
where
t2.col3 <> 'Y'
and t1.col1 = t2.col1
);

Thanks in Advance.

With Regards,
Raja.

On Jul 19, 6:36*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
Please go to asktom.oracle.com and type NOT EXISTS in the search box.
Who says it is not recommended?

jg
--
@home.com is bogus.
There are legs in the tape market yet. http://www.theregister.co.uk/2012/07/19/oracle_sl150/

joel garry wrote:
A certain "raja", in the post you replied to.