Evaluate the performance impact of indexing a varchar column in PostgreSQL where 40% of the rows contain an empty string represented as "". Compare the query execution plan between searching for IS NULL versus searching for = "". Provide a detailed explanation of storage differences and how the optimizer handles these distinct values.