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 -> foreign key: auto-index creation?

foreign key: auto-index creation?

From: Randall Parker <rgparker_at_west.net>
Date: 2000/07/24
Message-ID: <MPG.13e531edec0af0dd989848@news.onlynews.com>#1/1 






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.
Received on Mon Jul 24 2000 - 00:00:00 CDT












Original text of this message













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