Hi,

I have two similar queries, one of which ends with:

where XXX is null

and the other with:

where XXX is not null

The former makes use of the (ascending) index on the XXX column, but the
latter does not.

Why?

I've tried adding a descending index but I get the same result.

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

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