Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer execution-plan problem
Damien is correct. Null values are not index.
Jim
"Stefan Olausson" <qhsstol_at_hotmail.com> wrote in message
news:fda9c411.0111012147.7c3c949d_at_posting.google.com...
> 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:
> > >
> > >But why doesnt it work the same with "WHERE a IS NULL" ?
> > >Indexes cannot be used to find NULL-values or what ?
> >
> > Bingo ! :-)
> >
> > Null values are not indexed ... at least with regular indexes
> >
>
> Hmm, is that so?
> I've been hacking Oracle/SQL daily for almost 5
> years now, but must admit that was news to me.
> Funny I havent stumbled on that one before. Will RTFM :)
> Thanks for help.
> Best Regards,
Received on Fri Nov 02 2001 - 00:19:21 CST