Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer execution-plan problem
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 Thu Nov 01 2001 - 23:47:05 CST