Cuong, please post the Explain plan results and the column types (and
nullabilities) .
There are conditions that must be satisfied before a NOT IN can use the
optimizing HASH_ANTIJOIN (the main one is that the columns be not null )
"Cuong Hoang" <hoang_c_at_bls.gov> wrote in message
news:b16as2$ko4$1_at_blsnews.bls.gov...
> I tried to run query but it takes forever (each table has 1 miillon rows).
> Do you know any way to rewrite this query to make faster?
>
> "create table NO_BASE_DATE_PRICE as
> select ItemCode, IndexCode, ItemBaseDate
> from CELL_MAP
> where (ItemCode, IndexCode, ItemBaseDate)
> not in (select ItemCode, IndexCode, IndexRefMonth
> from CALC_PRICE);"
> Thanks,
> CH
>
>
Received on Wed Jan 29 2003 - 03:52:06 CST
