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

Home -> Community -> Usenet -> c.d.o.misc -> NOT IN conditions are extremly SLOW

NOT IN conditions are extremly SLOW

From: Robert Wehofer <thalion77_at_graffiti.net>
Date: Thu, 6 Oct 2005 09:14:27 +0200
Message-ID: <aa48e$4344cece$d4badae4$12370@news.chello.at> 





Hello!



I would like to execute following statement



SELECT count(*) FROM TABLE_A WHERE COL_A || '|' || COL_B NOT IN
(SELECT COL_A || '|' || COL_B FROM TABLE_B);


TABLE_A consists of 37.000 rows. The statement takes over 10 mins.



I have set analyzed indexes to perform the statement but it doesn't help
anyway.



Is it possible to modify the statement to get the same result with much
better execution performance?



Regards,


Robert
Received on Thu Oct 06 2005 - 02:14:27 CDT












Original text of this message













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