Subject | Re: [ib-support] Speed Issues |
---|---|
Author | Lele Gaifax |
Post date | 2002-10-27T22:53:39Z |
>>>>> On Sun, 27 Oct 2002 00:16:31 +0200, "Svein Erling Tysv?r" <svein.erling.tysvaer@...> said:SET> Well, Lele, it is not quite another consideration, but what
SET> makes deletes slow are things like indexes with low
SET> selectivity. E.g. if you have an index on "Country"...
SET> <snip>
Thank you, I know about low selectivity. I will double check asap, but
I'm almost sure that's not the reason, although it may be related to
index statistics. Is there any way to get a reasonable "picture" of
such stats of the db? I'm thinking at something more readable/succint
than "gstat -a -t", or eventually an URL explaining its output :)
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.