Re: Finding null values in a large table

From: Tim Dry <tldry_at_charter.net>
Date: 6 Dec 2002 11:50:03 -0800
Message-ID: <fad761ad.0212061150.4d803843@posting.google.com>

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3DEFEDF0.72B28A23_at_exesolutions.com>...
> 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

Unfortunately it is ongoing. Very ongoing.

-Tim Received on Fri Dec 06 2002 - 13:50:03 CST