| 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
| Thread | ||
|---|---|---|
| • Foreign Keys | Ben A.H. | 8 Oct |
| • Re: Foreign Keys | Jim Lyons | 8 Oct |
| • Re: Foreign Keys | Perrin Harkins | 8 Oct |
| • Re: Foreign Keys | Ben A.H. | 8 Oct |
| • Re: Foreign Keys | Arthur Fuller | 8 Oct |
| • RE: Foreign Keys | Ben A. Hilleli | 8 Oct |
| • Re: Foreign Keys | Peter Brawley | 8 Oct |