Re: not null and indexes

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.