>>>>> On Sat, 26 Oct 2002 17:03:56 -0400, "Ann W. Harrison" <aharrison@...> said:

AWH> At 11:33 PM 10/25/2002 +0200, Lele Gaifax wrote:

>> While on subject, I'm experiencing an inexpected slow response
>> from a SP that does several DELETE FROM xx WHERE PK>=:x in row

AWH> Approximately how many records would you expect to delete?

I cannot check right now, but I guess they were in the 5,000-10,000
range. This is not done very often, and it usually takes a few minutes
or so, but under some circumstances that skip my investigation effort
it seems taking forever: half an hour on good machines, all the night
on my poor 233Mhz :/

How can I inspect "index efficiency"? Or, to put in other words, when
does FB recalculate it? Another fact made me think its related to
that: for some reason, at one point another SP started taking lots of
time to execute, and after digging a little I discovered an index that
was there but not used at all. Forcing the plan, everything was
working great. Apparently it was not enough to disactivate/reactivate
it: I had reason of it only after dropping all indexes and recreating
them.

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.