-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Naveen,
Nahata (IE10)
Sent: Thursday, December 18, 2003
11:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Any known problems
using NOT IN ?
Doess the column crs.os_id_fk1 contain nulls?
Regards
Actually, because relational database conform to the rules of set theory,
I find it preferable to use MINUS wherever possible. Oracle optimizer
is trained to spot set operations and they usually generate sort/merge
or hash based execution plan, while NOT IN and NOT EXIST can generate
NL plan,
btw, a straight not in without a hash_aj, tends to get hideous bench marks.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/12/18 Thu AM 09:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any known problems using NOT IN ?
Actually, because relational
to be the best.
These are broad generalizations, but work well and are MUCH better than just guessing.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/12/18 Thu AM 09:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any known problems using NOT IN ?
Actually
not in without a hash_aj, tends to get hideous bench marks.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/12/18 Thu AM 09:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any known problems using NOT IN ?
Actually, because relational database conform
Siddharth,
The
NOT IN query fails to return rows, if the inner sub-query returns NULL values.
It is always recommended to use the NOT EXISTS clause, unless you are sure that
the inner query will not return any NULLs.
Regards,
Charu.
-Original Message-From: [EMAIL PROTECTED]
Doess the column crs.os_id_fk1 contain nulls?
Regards
Naveen
-Original Message-From: Siddharth Haldankar
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 18, 2003 10:54
AMTo: Multiple recipients of list ORACLE-LSubject: Any
known problems using NOT IN ?
Hi
Gurus,
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Charu
Joshi
Sent: Thursday, December 18, 2003
11:09 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Any known problems
using NOT IN ?
Siddharth,
The NOT IN query fails to return rows, if
the inner sub-query returns NULL