Subject | Re: [firebird-support] Index not used by "where xxx not null" query? |
---|---|
Author | Kjell Rilbe |
Post date | 2006-02-27T13:24:24Z |
Kjell Rilbe wrote:
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
> My index selectivity is currently 0.125 (freshly calculated). Could thatI'm now down to selectivity 0.066667 (freshly calculated). Same result.
> be the "problem"?
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