Re: Very long "WHERE" list.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 11 Jul 2004 15:12:08 +0000 (UTC)
Message-ID: <ccrlc8$rt9$1@sparta.btinternet.com>

I would phrase that as:

Putting 20000 values in an IN list MAY BE the most efficient way available of performing a lookup on those values

I have to say that I would be quite surprised if I came across an application where it was really necessary.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
news:40f14c73$0$18192$afc38c87_at_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 - 10:12:08 CDT