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

Home -> Community -> Usenet -> c.d.o.tools -> Indexing NULL values

Indexing NULL values

From: Mike Fotiou <mfotiou_at_magma.ca>
Date: Wed, 07 Mar 2001 04:30:08 GMT
Message-ID: <kPip6.34405$c7.10755835@news3.rdc1.on.home.com> 






Hi,



  Is there any way to index null values in Oracle?  Does the BITMAP type
index include NULL values?  We have several searches which use IS NULL/IS
NOT NULL conditions.  Currently, the Table Scan that Oracle uses is killing
query performance.  These fields do not really lend themselves to default
values (e.g. a closing date).  In SQL Server, there is the ability to
include NULLS when the index is built.  Is there any such feature in Oracle
8/8i?



Mike
Received on Tue Mar 06 2001 - 22:30:08 CST












Original text of this message













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