Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sum function force full table scan?

Re: sum function force full table scan?

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Tue, 23 Apr 2002 10:55:50 +0200
Message-ID: <aa37i9$710$1@news.mch.sbs.de>


Hi Ed,

NULL Values are not stored in a btree index. Therefor, if you ask '... where colum is null', the index is unusable.
A usual workaround is to use a dummy value, which semantically represents NULL, e.g. Jan. 1st 1900 for a
unknown time value.

Regards
Stephan Received on Tue Apr 23 2002 - 03:55:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US