Christopher Kings-Lynne kirjutas R, 07.03.2003 kell 07:28:
> Yeah, it's not really a problem for me, I just put the extra clause in.
>
> Is indexing excluding NULLs a common application of partial indexes?
For me it is ;)
> It's
> basically all I use it for, when a column has like 90-95% NULLS and I want
> to exclude them from the index.
> Is it worth hard-coding in the IS NOT NULL case?
I'd vote for it.
------------
Hannu