Not null and index

Hi,

I have a table with a column with a constraint not null and a index on this column

there are stats ion the table

when I do:

select * from test where no is null

the plan is using the index, why ?

Thanks in advance ...

9.2.0.6 Received on Tue Sep 18 2007 - 14:31:41 CDT