Tanovic' Branko wrote:

> ...
> On more thing I work with 120MB database curently.
> I run delete rows it need more than 4 hours to complete.
> with only 22 % usage for all cpus.

You probably have one or more indexes with many duplicates. You can run
the statistics and look for "max dups".
If this is the case (and you need these indexes) you need to redefine
them. Drop your old index and create a new one where you include the PK
(or some other highly selective field) as the last field. This should
speed up deletes (and updates).


--
Aage J.