<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-text-flowed" style="font-size: 18px;"
lang="x-western"><small>Hello list,
<br>
<br>
For a big table with more than 1,000,000 records, may I know
which update is quicker please?
<br>
<br>
(1) update t1
<br>
set c1 = a.c1
<br>
from a
<br>
where pk and
<br>
t1.c1 <> a.c1;
<br>
......
<br>
update t1
<br>
set c_N = a.c_N
<br>
from a
<br>
where pk and
<br>
t1.c_N <> a.c_N;
<br>
<br>
<br>
(2) update t1
<br>
set c1 = a.c1 ,
<br>
c2 = a.c2,
<br>
...
<br>
c_N = a.c_N
<br>
from a
<br>
where pk AND
<br>
( t1.c1 <> a.c1 OR t1.c2 <>
a.c2..... t1.c_N <> a.c_N)
<br>
<br>
<br>
Or other quicker way for update action?
<br>
<br>
Thank you
<br>
Emi
</small><br>
</div>
</body>
</html>