Re: performance problem : tkprof show many fetches with high elapsed time

> I know ! It's hard to believe but the ID column is unique. Proof just
> below. I would very much like to find out why the update which executes
> 12 times updates more than 72K records. I would expect only 12 updates
> since ID is unique. What is happening here ?

Whoa, that is wierd...!

Try running this SQL below.... (bearing in mind that the query will full table scan that large table and potentially take a while).

select count(distinct id) from PROFILESTOREDATA;

You should get 1 returned....

Matt Received on Fri Jan 05 2007 - 03:37:47 CST