Foreign key constraints or indexes...which comes first?
From: BiggsBM <biggsbm_at_aol.com>
Date: 1995/09/17
Message-ID: <43ijle$d6t_at_newsbf02.news.aol.com>#1/1
Date: 1995/09/17
Message-ID: <43ijle$d6t_at_newsbf02.news.aol.com>#1/1
When you declare a foreign key constraint on a table, I think Oracle
checks all rows in that table to make sure that their keys do exist in the
referenced table. And when you create an index on the values in a foreign
key, I think Oracle also goes through all of the rows in order to create
the index.
Thanks,
Brian Biggs
(bbiggs_at_cincom.com)
Received on Sun Sep 17 1995 - 00:00:00 CEST