Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Question on indexed nullable column

Question on indexed nullable column

From: <gmei_at_my-deja.com>
Date: 2000/05/11
Message-ID: <8ff72c$tcf$1@nnrp1.deja.com>#1/1

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.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 11 2000 - 00:00:00 CDT

Original text of this message

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