Subject Re: [ib-support] large deletions
Author Raul Chirea
Hi _/\/ando,

From: "Nando Dessena" <nandod@...>

> I fully agree with Helen here, and I have to add that an atomic index on
> a two-value column in a multi-million record table does not look exactly
> a speed enhancer to me.

It depends how the values of that column are distributed: if the two values
are distributed aprox. equally the index it's just a waste of space, but
more dispropotion between the two values is, more spped you'll get selecting
the minoritar ones - in our case those with "ACTIVE" = 'Y' (if you don't
believe me, try it ! In fact, thats why some RDBMS's offer a feature named
"partitioned tables", which is an enhaced version of what I've just told

Best regards !
(They still sell FoxPro, I've heard !)