Re: Finding null values in a large table

Tim Dry wrote:

> 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

Is this a one-time only or an ongoing requirement?

Dan Morgan Received on Thu Dec 05 2002 - 18:23:13 CST