RE: Go NULL values into an index?

From: Jeffery Stevenson <jeff_at_mpv.com>
Date: Mon, 8 Jan 2001 23:08:52 -0600
Message-Id: <10735.126077@fatcity.com>

AHA! It's a trick question...you shouldn't be able to put null values in a not null field--not to say that it can't be done, but that is beyond the scope of this question. :) Just so we get this right, it is supposed to be a nullable column, right?

Jeffery Stevenson
Chief Databeast Tamer, late at night with a tummy full of Coronas! Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: Haunschmidt Andreas VASL/FAS
[mailto:Andreas.Haunschmidt_at_voest.co.at] Sent: Monday, January 08, 2001 9:50 PM
To: Multiple recipients of list ORACLE-L Subject: Go NULL values into an index?

Hi Board Members!
Maybe a often posed question,
but I dare to ask you directly:

If there is a not null column named 'c1' and this column is part of an index

eg.: create (unique) index idx1 on t1(c1,c2...) - will the null values "go" into the index, so that a select * from t1 where c1 is null; or any other select statement can make use of the index ? Thanks in advance!

Andreas
Andreas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Haunschmidt Andreas VASL/FAS
INET: Andreas.Haunschmidt_at_voest.co.at

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 08 2001 - 23:08:52 CST