Message-Id: <10529.109394@fatcity.com>
From: dgoulet@vicr.com
Date: Thu, 15 Jun 2000 09:28:37 -0400
Subject: Re:Using 'In'...

Depending on the version of Oracle, 'in' gets interpreted as:

select x from <table> where zip = '650'
union select x from <table> where zip = '737'
union select x from <table> where zip = '850'

Consequently neither method may be more efficient.

____________________Reply Separator____________________
Subject:    Using 'In'...
Author: "Aldi Barco" <ipal@hotmail.com>
Date:       6/14/00 8:08 PM

Hi list,

For million of records table and non-indexed zip column, which one is faster 
:

update table1 set col1='x' where zip='650';
update table1 set col1='x' where zip='737';
update table1 set col1='x' where zip='850';

OR

update table1 set col1='x' where zip in ('650','737','850');


Thanks.

Aldi
Oracle DBA

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

-- 
Author: Aldi Barco
  INET: ipal@hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).