On 09/23/2014 12:35 PM, Emi Lu wrote:
Hello list,
For a big table with more than 1,000,000 records, may I know which
update is quicker please?
(1) update t1
set c1 = a.c1
from a
where pk and
t1.c1 <> a.c1;
..
update t1
set c_N = a.c_N
On Tue, Sep 23, 2014 at 8:35 PM, Emi Lu wrote:
> Hello list,
>
> For a big table with more than 1,000,000 records, may I know which update is
> quicker please?
>
> (1) update t1
> set c1 = a.c1
> from a
> where pk and
> t1.c1 <> a.c1;
> ..
> upda
Hello list,
For a big table with more than 1,000,000 records, may I know which
update is quicker please?
(1) update t1
set c1 = a.c1
from a
where pk and
t1.c1 <> a.c1;
..
update t1
set c_N = a.c_N
from a
where pk and