RE: Any known problems using NOT IN ?

2003-12-18 Thread Siddharth Haldankar
- 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

Re: Any known problems using NOT IN ?

2003-12-18 Thread Mladen Gogala
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,

Re: Re: Any known problems using NOT IN ?

2003-12-18 Thread ryan_oracle
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

Re: Re: Any known problems using NOT IN ?

2003-12-18 Thread ryan_oracle
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

RE: Re: Any known problems using NOT IN ?

2003-12-18 Thread Sami
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

RE: Any known problems using NOT IN ?

2003-12-17 Thread Charu Joshi
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]

RE: Any known problems using NOT IN ?

2003-12-17 Thread Naveen, Nahata (IE10)
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,

RE: Any known problems using NOT IN ?

2003-12-17 Thread Siddharth Haldankar
: [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