Did you try a filtered index using WHERE ... IS NOT NULL instead?
Or maybe an index on an expression coalesce(the_column, false) and then use that expression the where clause?
Did you try a filtered index using WHERE ... IS NOT NULL instead?
Or maybe an index on an expression coalesce(the_column, false) and then use that expression the where clause?