ple recipients of list ORACLE-L
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 know
elative to the inner query, minus tends 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 <
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
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
Message-
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
: [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
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,
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]