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 -> Re: Very long "WHERE" list.

Re: Very long "WHERE" list.

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Mon, 12 Jul 2004 00:19:31 +1000
Message-ID: <40f14c73$0$18192$afc38c87@news.optusnet.com.au> 





Jonathan Lewis apparently said,on my timestamp of 11/07/2004 11:40 PM:



> Notes in-line.

> 

> 




So let me see: you agree that putting 20000 values in
an IN list is an efficient way of performing a
lookup on those values?



-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam


Received on Sun Jul 11 2004 - 09:19:31 CDT












Original text of this message













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