How to check if index was updated?

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Apr 2006 15:42:27 -0400

Got a query from my developers, they are trying to use the
"update xxx set row " syntax to modify a row using a record.

How would I verify that pk index will not get updated if only non
indexed columns were changed in the record?

is there an easy way? btw this is on 10104.

Got RAC?

Other related posts: