List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:October 8 2008 7:40pm
Subject:Re: Foreign Keys
View as plain text  
On Wed, Oct 8, 2008 at 11:56 AM, Jim Lyons <jlyons4435@stripped> wrote:
> Indexes speed up joins.  Foreign keys should be indexes themselves, so they
> can also speed up joins.  If the FK is not an index, it won't help.  So,
> index your FKs

If you add a FOREIGN KEY constraint in MySQL 5+ it adds an index automatically.

- Perrin
Foreign KeysBen A.H.8 Oct
  • Re: Foreign KeysJim Lyons8 Oct
    • Re: Foreign KeysPerrin Harkins8 Oct
  • Re: Foreign KeysBen A.H.8 Oct
    • Re: Foreign KeysArthur Fuller8 Oct
      • RE: Foreign KeysBen A. Hilleli8 Oct
        • Re: Foreign KeysPeter Brawley8 Oct