Re: Indexes and Foreign Keys

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 11 Mar 2006 23:13:10 GMT
Message-ID: <Xns97839AB4B1665ianalvistahotmailcom@70.169.32.36>

"Mark A" <nobody_at_nowhere.com> wrote in
news:0vidnQMdy8_Hy47ZRVn-iA_at_comcast.com:

> "ianal Vista" <ianal_vista_at_hotmail.com> wrote in message
> news:Xns97838BAF5D450ianalvistahotmailcom_at_70.169.32.36...

>>
>> You should always create indexes for all foreign keys;
>> otherwise the whole child must be locked when updating the parent
>> table. 

>
> I would disagree that all FK's need indexes.
>
> First, many PK's on parent tables never get updated, and they only get
> deleted if all the children are already gone. These are mostly small
> code tables.
>
> Second, even if a PK on a parent table where to change,

Please provide a functioning example SQL statement that 'changes' a PK value. Received on Sat Mar 11 2006 - 17:13:10 CST