Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to check if index was updated?

Re: How to check if index was updated?

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 26 Apr 2006 18:00:56 -0400
Message-ID: <cd4305c10604261500o560e52caxee7e87cef0a3d1b7@mail.gmail.com>


Well two points, beware some tools can be updating the primary key, even when this didn't changed.

Did you tried logminer or similar utilities? there you can see exactly the changes, so if the primary key colums are changing means, the index is being updated :)

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 26 2006 - 17:00:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US