2 Replies Latest reply: Nov 30, 2012 6:49 AM by ShishirTekadeR RSS

    Diff in update query. with Primary key and with Index

      Hi All,
      can anyone tell me what is the difference when i am writing a update query,Update data with primary key vs updating data with index.

      for Example 1
      Table x having primary key No.

      update x set Name='abc' where no='1' ( here column 'no' is primary key)

      Another example 2

      Update x set Name='abc' where city='xxx',job='yyy' (here columns city having index .And on column job doesn't Have index.

      Can anyone tell me the difference in terms of how oracle update mechanism work in both the case.

      Thanks in advance.

      Edited by: user10366531 on Nov 30, 2012 2:25 AM