Column with NULLs, how would it impact an index
- From: Nik Tek <niktek2005@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Apr 2014 12:42:23 -0700
Hi,
I have question on index in Oracle.
Say, I have a table T1
CREATE TABLE T1(C1 INT NOT NULL, C2 VARCHAR2(50) NULL, CONSTRAINT PK_T1_C1
PRIMARY KEY (C1));
CREATE INDEX IDX_T1_C2 ON T1(C2);
The column C2 accepts NULLS,
Question: Does this have any impact on the index?
The table could have millions of rows(15-20 million).
Can anyone send me some pointers on it, to read about indexes on null
columns.
Thank you
Nik
Other related posts:
