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:21:44 +1000
Message-ID: <40f14cf8$0$18192$afc38c87@news.optusnet.com.au>


Andy Hassall apparently said,on my timestamp of 11/07/2004 11:08 PM:

>
> mysql> \. monstroInlist.sql
> +----------+
> | count(*) |
> +----------+
> | 10001 |
> +----------+
> 1 row in set (2.38 sec)

Interesting. Must be doing some lookup optimisation to get this time.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Sun Jul 11 2004 - 09:21:44 CDT

Original text of this message

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