Re: Index on nullable columns

Dirk Köser wrote:
>
> Hello all
>
> As for Oracle v7.3 I know that:
> If there is an index on a nullable column
> then no information is stored for rows with NULL-values
> which causes full table scans for query predicates like
> "col IS NULL"
>
> Has this behaviour changed for version 8.0 / 8.1 ?
>
> Thanks for any comments
>
> Dirk

Nope...

..although bitmap indexes do not behave the same way as the classic "nulls are not stored" statement

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse