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 -> Performance question - Updage with Correlated/Non Correleated Sub Query

Performance question - Updage with Correlated/Non Correleated Sub Query

From: kdc <kcameron_at_navicsys.com>
Date: 2000/04/24
Message-ID: <QL_M4.160834$AT6.227794@dfw-read.news.verio.net>#1/1

Any whay of predicting which will perform better

update table1
set column_name = 'New Value'
where
exists (select pk from table2 where table1.table2_fk = table_2.pk)

update table1
set column_name = 'New Value'
where
table2_fk in (select pk from table2) Received on Mon Apr 24 2000 - 00:00:00 CDT

Original text of this message

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