Re: Optimizer execution-plan problem

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

There is a case when Null can be indexed but I cannot seem to remember when :-/
Someone out there ?

-- 
Damien