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>
Date: 11 Jul 2004 22:08:14 -0700
Message-ID: <73e20c6c.0407112108.1384128f@posting.google.com>


ctcgag_at_hotmail.com wrote in message news:<20040711182210.185$f7_at_newsreader.com>...
>
> If there is not a way to obtain those 20,000 values by any compact query
> from within the database, I think that that is a very efficient way
> of performing a look-up on those values.
>

If the statement does not run, then it is not efficient. :)
Which was the problem of the OP, no?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Mon Jul 12 2004 - 00:08:14 CDT

Original text of this message

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