Re: foreign key: auto-index creation?

"Randall Parker" <rgparker_at_west.net> wrote in message news:MPG.13e531edec0af0dd989848_at_news.onlynews.com...
> 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.
>

Oracle doesn't create indexes for foreign keys automatically, it does for primary keys and unique keys.
If you visit http://osi.oracle.com/~tkyte you will find an update cascade package, which also includes a script to find the unindexed foreign keys.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Jul 24 2000 - 00:00:00 CDT