Re: Index on Foreign key necessary to prevent lock problems ?

From: <jtesta_at_my-dejanews.com>
Date: Fri, 29 May 1998 17:52:21 GMT
Message-ID: <6kmskl$it8$1@nnrp1.dejanews.com>

You always want to index your FK field(s) to prevent locking problems.

In article <356E8DD8.C701770E_at_arpege.imaginet.fr>, philippe <philippe_at_arpege.imaginet.fr> wrote:
>
> I read that it might be necessary to put an index on an Foreign key to
> prevent lock problems on the master table.
>
> Any Idea
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 12:52:21 CDT