Re: Index on nullable column

From: <ctcgag_at_hotmail.com>
Date: 04 Oct 2003 17:24:50 GMT
Message-ID: <20031004132450.585$i2@newsreader.com>

"Jack Wang" <nospam_at_nospam.com> wrote:
> 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 you provide your test?

> Can someone clarify?

Yes. You probably have a predicate which excludes null values, but don't know it.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB

Received on Sat Oct 04 2003 - 12:24:50 CDT