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: Is This the varchar2 ZLS Issue?

Re: Is This the varchar2 ZLS Issue?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 22 Mar 2006 09:58:22 -0800
Message-ID: <1143050302.837857.34480@e56g2000cwe.googlegroups.com> 





I have no trouble with the concept of NULL.  In the real world data is
often unknown or missing.  With single column indexes the lack of data
creates a sparse index since nulls are not indexed in Oracle.  Sparse
indexes can be wonderful for performance in cases where the majority of
the rows have no data in the column.



IMHO -- Mark D Powell --
Received on Wed Mar 22 2006 - 11:58:22 CST












Original text of this message













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