Question on indexed nullable column

From: Guang Mei <zlmei_at_hotmail.com>
Date: Thu, 11 May 2000 21:02:46 GMT
Message-Id: <10494.105427@fatcity.com>

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 Received on Thu May 11 2000 - 16:02:46 CDT