Re: Indexes and Foreign Keys

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 11 Mar 2006 21:44:34 GMT
Message-ID: <Xns97838BAF5D450ianalvistahotmailcom@70.169.32.36>

"Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote in news:akHQf.31462$2O6.26201_at_newssvr12.news.prodigy.com:

> I've read conflicting thoughts about indexes and foreign keys.
>
> One train of thought has it that you always create indexes for all
> foreign keys. The other train of thought said that not all foreign
> keys really need an associated index.
>
> Are there general rules of thumbs to use concerning this?
>
>
>

You should always create indexes for all foreign keys; otherwise the whole child must be locked when updating the parent table. Received on Sat Mar 11 2006 - 15:44:34 CST