Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Finding null values in a large table
I have a fairly large table (millions of rows) and I would like to be
able to find rows that have a null value in a particular column. I
know that regular indexes don't contain null values and thus an index
on this particular column probably wouldn't help. I believe that
bitmap indexes include nulls, but bitmap indexes are supposedly
inefficient when the column is too selective. Are there other
solutions?
-Tim Received on Thu Dec 05 2002 - 17:45:43 CST