Dereck L. Dietz wrote:
> 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?
>
>
The ROT is to create indexes. Careful inspection will learn,
not all foreign keys need indexes.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sun Mar 12 2006 - 04:58:58 CST
