Is it possible to make an index in FB ignore nulls? I mean, can the
index be made to not store in the index those records with null in the
indexed field?

I have a 150 million table with some fields that will be 99% or more
null, but in some situations I will have to lookup one specific record
based on a non-null value of that field. Seems like such a waste to
store all those nulls in the index... Without the index, the query takes
about an hour, which is not acceptable.

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


[Non-text portions of this message have been removed]