Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> Re: foreign key

Re: foreign key

From: Yoram Zilberberg <yoram_at_daemon.co.il>
Date: 1997/05/15
Message-ID: <337B5109.7BFB@daemon.co.il>#1/1

an index is not created for an FK constraint but you should create one or the dml on the master table (namelly delete of a master record) will perform a full table scan on the detail tables.

designer2000 has a default indexing that does just that. Received on Thu May 15 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: Gary Melhaff: "Re: foreign key"
Previous message: Thomas Kyte: "Re: foreign key"
In reply to: David Turner: "foreign key"
Next in thread: Gary Melhaff: "Re: foreign key"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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