Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Performance question - Updage with Correlated/Non Correleated Sub Query
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
![]() |
![]() |