Re: Index and Foreign key
From: James Williams <willjamu_at_mindspring.com>
Date: Tue, 29 Apr 2003 00:49:54 GMT
Message-ID: <3eadcc11.8178105_at_nntp.mindspring.com>
Date: Tue, 29 Apr 2003 00:49:54 GMT
Message-ID: <3eadcc11.8178105_at_nntp.mindspring.com>
On 28 Apr 2003 06:56:40 -0700, Mark.Powell_at_eds.com (Mark D Powell) wrote:
Mark,
You are correct. I was not specific enough.
>
>
>James, my experience says that the majority of FK constaints do not
>need an index to support them since they point to relatively static
>tables. Unless row deletes take place or updates on the key there
>will never be a need for the index to support locking. Probably only
>about 20% of FK constaints actually need an index to support efficient
>usage.
>
>There have been several threads on this topic in the past.
>
>IMHO -- Mark D Powell --
Received on Tue Apr 29 2003 - 02:49:54 CEST