Thread

Re: [HACKERS] Index not used on simple select

Ole Gjerde <gjerde@icebox.org> — 1999-07-23T19:57:59Z

On Fri, 23 Jul 1999, Tom Lane wrote:
> It looks like the highly skewed distribution of nsn values (what you
> sent me had 997 '' entries, only 3 non-empty strings) is confusing the

As a note, it doesn't seem to matter wether the field has '' or NULL.
Even after I do a update to set all all rows with '' to NULL, it still
does the same thing.

Also, my full set of data is not quite so skewed.  The nsn field has about
450,000 non-empty rows in it.

Thanks,
Ole Gjerde