RE: Question on indexed nullable column

From: <awaisb_at_paktel.com>
Date: Fri, 12 May 2000 11:34:20 +0500
Message-Id: <10494.105451@fatcity.com>

If an index is created on nullable column, it will not create any problem and put the null value at first place of the index. I think if you make any query against that table for null values than it might be fatser.

-----Original Message-----
From: Guang Mei [mailto:zlmei_at_hotmail.com] Sent: Friday, May 12, 2000 3:17 AM
To: Multiple recipients of list ORACLE-L Subject: Question on indexed nullable column

Hi:

In Oracle database, if I do:

create table T1 (

	C1  number(9) NOT NULL,
	C2  number(9));

create index INDX1 on T1(C1);
create index INDX2 on T1(C2);

Is here a performance penalty, or other problems if an indexed column is nullable (such as C2 here)? If yes, why?

Thanks.

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

-- 
Author: Guang Mei
  INET: zlmei_at_hotmail.com

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 Fri May 12 2000 - 01:34:20 CDT