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

Home -> Community -> Usenet -> c.d.o.misc -> Re: not null and indexes

Re: not null and indexes

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 13 Feb 2005 10:02:54 -0800
Message-ID: <420f964e@news.victoria.tc.ca>


vertigo (ax178_at_wp.pl) wrote:
: Hello

: Does oracle create automaticly indexes on not null columns ?

No.

But if you define constraints on a column then oracle may implement that constraint using an index on the column.

Prime example being a primary key - it must be unique and a unique index is used to enforce that - so in that case those columns will be in an index. Also in that case, the columns involved will end up being not null columns.

--

This space not for rent.
Received on Sun Feb 13 2005 - 12:02:54 CST

Original text of this message

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