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

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer execution-plan problem

Re: Optimizer execution-plan problem

From: Stefan Olausson <qhsstol_at_hotmail.com>
Date: 5 Nov 2001 07:53:31 -0800
Message-ID: <fda9c411.0111050753.22c671a8@posting.google.com> 





damien.salvador_at_via.ecp.fr (Damien Salvador) wrote in message news:<slrn9u2icq.aj0.damien.salvador_at_zen.via.ecp.fr>...


> On 1 Nov 2001 05:05:01 -0800, Stefan Olausson 

> <qhsstol_at_hotmail.com> a écrit:

> There is a case when Null can be indexed but I cannot seem to remember when...




Yes, NULL-values are always indexed when you use BITMAPPED indexes,
if I read the documentation correctly.


But such are only useful when you have 


relatively few distinct values in a column.



/Stefan
Received on Mon Nov 05 2001 - 09:53:31 CST












Original text of this message













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