You can get nulls indexed in some circumstances, such as ...
  • Using a bitmap index -- but don't do it on an OLTP systems
  • Use a composite index, where the other column is not null when the address column is null
  • Use a function-based index ... in thiscase you can choose to index only null values.


The second option is the easiest.