Re: Foreign key: auto-create index for it?

Posted in 2000

Obnoxio The Clown — Mon, 24 Jul 2000 09:48:47 BST — source: Informix-list mailing list archive (1991-1998)

From: Randall Parker <rgparker@west.net> > >Er, > >I meant to say "Informix" below, not "Oracle". Sorry about that. Of course, it's an easy mistake to make. >In news:<MPG.13e5317d51eba6a8989847@news.onlynews.com>, rgparker@west.net >says... > > I've been told that Sybase ASA automatically creates an index in the > > referring table for all declared foreign key constraints. Does Oracle do > > likewise? > > > > DB2 and MS SQL Server both require explicit creation of indexes to > > support foreign keys. I'm wondering if Oracle is more like them. You can do both. If you pre-create the index, Informix will use it to support the constraint, if you don't pre-create an appropriate index, Informix will create one for you. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com