Re: How to check if index was updated?

*easiest* way, trace it and look at the recursive sql. or you could dump the relevant index blocks to disk before and after.

Me, I probably wouldn't care.

On 4/26/06, rjamya <rjamya_at_gmail.com> wrote:
> 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.
>
> TIA
> Rjamya
> ----------------------------------------------
> Got RAC?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l