|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Foreign Keys
From: Jim Lyons (jlyons4435
gmail.com)
Date: Wed Oct 08 2008 - 10:56:19 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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. <bencanview.com> 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=jlyons4435gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]