Re:Using 'In'...

From: <dgoulet_at_vicr.com>
Date: Thu, 15 Jun 2000 09:28:37 -0400
Message-Id: <10529.109394@fatcity.com>

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_at_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_at_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_at_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).

Received on Thu Jun 15 2000 - 08:28:37 CDT