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

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexes

Re: Indexes

From: Brad Worsfold <bworsfold_at_vic.lgs.ca>
Date: 1997/07/22
Message-ID: <01bc96d3$3f25a9b0$0faf22cf@cerulean>#1/1

I know that you can create an index like this, but does Oracle actually add new entries to the index if one of the columns is null???? That is the question.

Any ideas??

Thanks,

Tomm Carr <tommcatt_at_geocities.com> wrote in article <33D4DE6A.5BC0_at_geocities.com>...
> Brad Worsfold wrote:
> >
> > If I want to create a composite index on two columns, will Oracle Index
 a
> > row if one
> > of the columns is optional? Meaning that one column has a value, the
 other
> > is null???
>
> If I am not mistaken (meaning I'm too lazy to look it up at the moment)
> you can create a *non-unique* index on a column that allows null values.
>
> > I was told that Indexes are not created on rows with Null Values?
>
> So. There you go listening to people again. Never take anyone's word
> on anything (including mine). Create a test table and try it. See what
> happens. If it can't be done the server won't get all huffy and refuse
> to talk to you anymore!
>
> --
> Tomm Carr
> --
> "Can you describe your assailant?"
> "No problem, Officer. That's exactly what I was doing when he hit me!"
>
  Received on Tue Jul 22 1997 - 00:00:00 CDT

Original text of this message

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