From: Martijn Tonies
Date: October 13 2004 4:11pm
Subject: Re: InnoDB and foreign keys
List-Archive: http://lists.mysql.com/mysql/174110
Message-Id: <004701c4b13f$5d9a8440$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> does anybody know if Foreign keys increase the performance of select
querys?
> example.
> DB1 has only INNODB tables.
> DB2 has the same structure as DB1 with all possible foreign keys.
>
> is the same query faster on DB1 or DB2?

Why should it increase performance?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com