On Jun 15, 7:50 am, "Jaap W. van Dijk" <j.w.vand..._at_hetnet.nl> wrote:
> 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.
Did you check metalink for a bug or change that impacts 9.2.0.5?
Received on Fri Jun 15 2007 - 07:06:14 CDT
