Re: Questions on Indexes

Posted in 1999

Obnoxio The Clown — Wed, 28 Apr 1999 13:24:19 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: jroe@erols.com (Jon M. Roe) >> >>4) So, in my case, do I need to try to create my own index on column >>A for any purpose, that is, would it help? Of course it appears that >>I can't do this unless I get rid of the foreign key. > >No, you don't need to. It won't be any faster and will make it >impossible to implement referential integrity. Jeez, I really should RTFM before I open my big yap. It doesn't make it impossible to implement referential integrity. Sorry. I think the rest of it stands. ;-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com