Re: PARTition elimination

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 18 Nov 2005 11:27:05 -0800
Message-ID: <1132342022.888201@yasure>

hopehope_123 wrote:
> Hi Daniel ,
>
> dwh_isyeri_kod is nullable . How does 'changing the column to not null
> ' effect the query?
>
> (The index is bitmap so it contains null values also , isnt it?)
>
> Kind Regards,
> tolga

No Oracle index contains NULLs.

Making an indexed column NOT NULL allows Oracle to count the index entries and not have to read the table.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Nov 18 2005 - 13:27:05 CST