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 -> Index on nullable column

Index on nullable column

From: Jack Wang <nospam_at_nospam.com>
Date: Sat, 04 Oct 2003 03:51:29 GMT
Message-ID: <5trfb.44756$H86.1115040@news1.telusplanet.net>


As per http://www.ixora.com.au/tips/not_null.htm,

"An index on a nullable column cannot be used to drive access to a table unless the query contains one or more predicates against that column that exclude null values"

Though based on my test, index on a nullable column is used to access a table. Can someone clarify?

DB: 9.2.0.3
OS: W2K AS

Thanks.

Received on Fri Oct 03 2003 - 22:51:29 CDT

Original text of this message

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