Re: Index on nullable columns

From: <decompton_at_worldnet.att.net>
Date: 2000/06/19
Message-ID: <8ilg0p$n1n$1@nnrp1.deja.com>#1/1

Same behavior.....unless you use bitmap indexes.

dave

In article <8il1vl$qpq1_at_ppd00021.deutschepost.de>, "Dirk Köser" <D.Koeser_at_DeutschePost.de> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 19 2000 - 00:00:00 CDT