That's what I currently do. After reading the conflicting ideas I just was
wondering if I was doing anything wrong by creating indexes for my foreign
keys.
"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message
news:Xns97838BAF5D450ianalvistahotmailcom_at_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:48:28 CST
