Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Finding null values in a large table

Finding null values in a large table

From: Tim Dry <tldry_at_charter.net>
Date: 5 Dec 2002 15:45:43 -0800
Message-ID: <fad761ad.0212051545.14b89cc7@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US