List:General Discussion« Previous MessageNext Message »
From:Jim Lyons Date:October 8 2008 3:56pm
Subject:Re: Foreign Keys
View as plain text  
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

On Wed, Oct 8, 2008 at 10:43 AM, Ben A.H. <ben@stripped> wrote:

> Does using foreign keys simply enforce referential integrity OR can it also
> speed up JOIN queries?
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Thread
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