I have a below query:
SELECT * FROM BUSINESS_PL
WHERE ADDRESS IS NULL;
from the above table, in the explain plan, it does a full table scan. but the cost is very low b/c the table had less than 100 records. Any way, the question is "can we put the index on the ADDRESS column"??? even the column is NULL???