Subject Re: [firebird-support] Index not used by "where xxx not null" query?
Author Kjell Rilbe
Kjell Rilbe wrote:

> My index selectivity is currently 0.125 (freshly calculated). Could that
> be the "problem"?

I'm now down to selectivity 0.066667 (freshly calculated). Same result.

But on the other hand, I've got 361 nulls among a total of 581 records.
Does Firbird detect this and decide that indices are of no use?

Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64