Hi guys.

I have one table that currently has 100 000 000 records. PageSize is 16384.
Index statistics for primary key are 0.000000 (I've recomputed them).

Over a few days inserting and updating this table slowed down significantly. When I try to update one row:

UPDATE TABLE SET VALUE=X WHERE PK_COLUMN_ID =12335343

update executes in 0.250 miliseconds.

What is surprising for me that just few days ago everything was fine.. how could I speed thing up? What could happen over these few days?

Thanks in advance.

It's hard to tell without more information.

But the first thing I would look out is the transaction counters.

Perhaps you have some open transaction that is preventing the garbage collection process and acumulating record versions.

use GSTAT -h to get the header information of your database and post it back.

see you !