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 -> process long time query!

process long time query!

From: Cuong Hoang <hoang_c_at_bls.gov>
Date: Tue, 28 Jan 2003 11:27:00 -0500
Message-ID: <b16as2$ko4$1@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 Tue Jan 28 2003 - 10:27:00 CST












Original text of this message













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