Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cannot force antijoin in UPDATE (9.2.0.5.0)

Cannot force antijoin in UPDATE (9.2.0.5.0)

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Fri, 15 Jun 2007 04:50:55 -0700
Message-ID: <1181908255.353529.4790@m36g2000hse.googlegroups.com>


Hi,

I'm doing the following update:

UPDATE table1 t1
SET field1 = NULL
WHERE field2 NOT IN (SELECT /*+ HASH_AJ */ t2.field2 FROM table2 t2)

Instead of doing the ANTIJOIN, The database is performing a FILTER on table1 by reading table2. Why doesn't the hint work? For several tables other that table1 the hint does work.

Jaap. Received on Fri Jun 15 2007 - 06:50:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US