update - which way quicker?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Good morning,

Tried to compare Table1 based on Table2

. update table1.col = false
  if table1.pk_cols not in table2.pk_cols



For the following two ways, (2) always performs better than (1) right,
and I need your inputs.
========================================================================
(1) update table1
    set col = false
    where table1.pk_co1 || table1.pk_col2.... || table1.pk_colN

    NOT IN

    (select pk_co1 || pk_col2.... || pk_colN
     from table2
     )

(2) ResultSet(rs) =
    select pk_col1||pk_col2... || pk_colN
    from table1
    left join table2 using (pk_col1..., pk_colN)
    where table2.pk_col1 is null

    Then for each rs record, do:
    update table1
    set col = false
    where col1||... colN in rs.value

Thanks a lot!


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux