>>>>> On Fri, 25 Oct 2002 10:19:04 -0400, "Ann W. Harrison" <aharrison@...> said:

AWH> No. Defining the right set of indexes is the best way to
AWH> improve speed.

While on subject, I'm experiencing an inexpected slow response from a
SP that does several DELETE FROM xx WHERE PK>=:x in row on a set of
tables. There are no triggers/secondary keys involved. The sweep
interval should be 0, but since I was working on a freshly restored db
sweep shouldn't be the case. When I tried doing it's work by hand,
thus executing 10 DELETEs, it took a reasonable amount of time to
complete.

Is there *any* other consideration to do in such situation?

thanx&bye,
lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.