Re: Finding null values in a large table

Tim Dry wrote:

> I have a fairly large table (millions of rows)

Under 10 million? That would be called a smallish table by some. :-)

> and I would like to be able to find rows that have a null value in a
> particular column.

<snipped>

I will leave the index and null discussion for someone else to get into. :-)

> Are there other solutions?

Yep. For a quick solution to find those "problem" rows. PQ. Something like this:

SELECT
  /*+ FULL(t) PARALLEL(t,10) */
  t.*
FROM my_big_table t
WHERE t.some_column IS NULL

--
Billy