Re: Optimizer execution-plan problem

Stefan Olausson wrote:
>
> damien.salvador_at_via.ecp.fr (Damien Salvador) wrote in message news:<slrn9u2icq.aj0.damien.salvador_at_zen.via.ecp.fr>...
> > On 1 Nov 2001 05:05:01 -0800, Stefan Olausson
> > <qhsstol_at_hotmail.com> a écrit:
> > There is a case when Null can be indexed but I cannot seem to remember when...
>
> Yes, NULL-values are always indexed when you use BITMAPPED indexes,
> if I read the documentation correctly.
> But such are only useful when you have
> relatively few distinct values in a column.
>
> /Stefan

A fudge around the "missing" nulls problem is a function based index on nvl or decode... Not great, but it saves storing nonsense in tables

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."