Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Cannot force antijoin in UPDATE (9.2.0.5.0)
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