Re: Index and Foreign key

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 Mon Apr 28 2003 - 19:49:54 CDT