Using 'In'...

From: Aldi Barco <ipal_at_hotmail.com>
Date: Thu, 15 Jun 2000 09:56:00 JAVT
Message-Id: <10528.109349@fatcity.com>

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 Received on Wed Dec 31 1969 - 17:59:59 CST