Kjell Rilbe wrote:

> 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?

Now at stat 0.004484 (freshly calculated), and not a single null left.
Still the same result regarding the query plans: is null uses the
ascending index but is not null doesn't use neither the ascending, nor
the descending index.

What's going on? I'm sure there's just something I'm missing here...

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