Originally posted by paladin
> Any way, the question is "can we put the index on the ADDRESS column"??? even the column is NULL???

And the answer is, yes. Note, however, there will be no index entries for the NULL values. So an index on a 100% NULL column will be empty.
How about the three methods i just gave for getting those nulls included in an index?